| 04060184.xhp (67e470da) | 04060184.xhp (514ce53b) |
|---|---|
| 1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> 3 4<!--*********************************************************** 5 * 6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information --- 157 unchanged lines hidden (view full) --- 166<paragraph xml-lang="en-US" id="par_id3149734" role="code" l10n="U" oldref="160">AVERAGEA(Value1; Value2; ... Value30)</paragraph> 167<paragraph xml-lang="en-US" id="par_id3155260" role="paragraph" l10n="CHG" oldref="161"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph> 168<paragraph xml-lang="en-US" id="hd_id3149504" role="heading" level="3" l10n="U" 169oldref="162">Example</paragraph> 170<paragraph xml-lang="en-US" id="par_id3150864" role="paragraph" l10n="U" oldref="163"> 171<item type="input">=AVERAGEA(A1:A50)</item> 172</paragraph> 173</section> | 1<?xml version="1.0" encoding="UTF-8"?> 2<helpdocument version="1.0"> 3 4<!--*********************************************************** 5 * 6 * Licensed to the Apache Software Foundation (ASF) under one 7 * or more contributor license agreements. See the NOTICE file 8 * distributed with this work for additional information --- 157 unchanged lines hidden (view full) --- 166<paragraph xml-lang="en-US" id="par_id3149734" role="code" l10n="U" oldref="160">AVERAGEA(Value1; Value2; ... Value30)</paragraph> 167<paragraph xml-lang="en-US" id="par_id3155260" role="paragraph" l10n="CHG" oldref="161"><emph>Value1; Value2;...Value30</emph> are values or ranges. Text has the value of 0.</paragraph> 168<paragraph xml-lang="en-US" id="hd_id3149504" role="heading" level="3" l10n="U" 169oldref="162">Example</paragraph> 170<paragraph xml-lang="en-US" id="par_id3150864" role="paragraph" l10n="U" oldref="163"> 171<item type="input">=AVERAGEA(A1:A50)</item> 172</paragraph> 173</section> |
| 174<section id="averageif"> 175<bookmark xml-lang="en-US" branch="index" id="bm_id3148754K1"><bookmark_value>AVERAGEIF function</bookmark_value> 176</bookmark> 177<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTB" id="bm_id3149690K1" localize="false"/> 178<paragraph xml-lang="en-US" id="hd_id3148754K1" role="heading" level="2" l10n="U" 179 oldref="157">AVERAGEIF</paragraph><comment>kschenk added this entry </comment> 180<paragraph xml-lang="en-US" id="par_id3145138K1" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MITTELWERTB">Average the values of cells in a range that meet a criteria.</ahelp></paragraph> 181<paragraph xml-lang="en-US" id="hd_id3153326K1" role="heading" level="3" l10n="U" 182oldref="159">Syntax</paragraph> 183<paragraph xml-lang="en-US" id="par_id3149734K1" role="code" l10n="U" >AVERAGEIF( Reference R ; Criterion C [ ; Reference A ] )</paragraph> 184<paragraph xml-lang="en-US" id="par_id3155260K1" role="paragraph" l10n="CHG" > If reference A is omitted, averages the values of cells in the reference range R that meet the Criterion C. If reference A is given, averages the values of cells of a range that is constructed using the top left cell of reference A and applying the dimensions, shape and size, of reference R. Does not accept constant values as reference parameters.</paragraph> 185<paragraph xml-lang="en-US" id="par_id3145139K1" role="paragraph" l10n="U" >If no cell in range R matches the Criterion C, an Error is returned. If no Numbers are in the range to be averaged, an Error is returned.</paragraph> 186<paragraph xml-lang="en-US" id="hd_id3149504K1" role="heading" level="3" l10n="U" 187oldref="162">Examples</paragraph> 188<paragraph xml-lang="en-US" id="par_id3150864K1" role="paragraph" l10n="U"> 189<item type="input">=AVERAGEIF(A1:A50;">"0)</item> 190will return the average of A1:A50 of all positive values in the range. 191</paragraph> 192</section> 193<section id="averageifs"> 194<bookmark xml-lang="en-US" branch="index" id="bm_id3148754K2"><bookmark_value>AVERAGEIFS function</bookmark_value> 195</bookmark> 196<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MITTELWERTC" id="bm_id3149690K2" localize="false"/> 197<paragraph xml-lang="en-US" id="hd_id3148754K2" role="heading" level="2" l10n="U" 198 oldref="157">AVERAGEIFS</paragraph><comment>kschenk added this entry </comment> 199<paragraph xml-lang="en-US" id="par_id3145138K2" role="paragraph" l10n="U"><ahelp hid="HID_FUNC_MITTELWERTC">Average the values of cells that meet multiple criteria in multiple ranges.</ahelp></paragraph> 200<paragraph xml-lang="en-US" id="hd_id3153326K2" role="heading" level="3" l10n="U" 201oldref="159">Syntax</paragraph> 202<paragraph xml-lang="en-US" id="par_id3149734K2" role="code" l10n="U" >AVERAGEIFS( Reference A ; Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph> 203<paragraph xml-lang="en-US" id="par_id3155260K2" role="paragraph" l10n="CHG" >Averages the values of cells in the reference range A that meet the Criterion C1 in the reference range R1 and the Criterion C2 in the reference range R2, and so on.</paragraph> 204<paragraph xml-lang="en-US" id="par_id3145139K2" role="paragraph" l10n="U" >All reference ranges shall have the same dimension and size, else an Error is returned. A logical AND is applied between each array result of each selection; a cell of reference range A is evaluated only if the same position in each array is the result of a Criterion match. If no numbers are in the result set to be averaged, an Error is returned.</paragraph> 205<paragraph xml-lang="en-US" id="hd_id3149504K2" role="heading" level="3" l10n="U" 206oldref="162">Example</paragraph> 207<paragraph xml-lang="en-US" id="par_id3150864K2" role="paragraph" l10n="U"> 208<item type="input">=AVERAGEIFS(A1:A50;B1:B25;">"0)</item>+will return the average of A1:A50 if all cells in the range B1 to B25 are greater than 0. 209</paragraph> 210</section> |
|
| 174<section id="mode"> 175<bookmark xml-lang="en-US" branch="index" id="bm_id3153933"><bookmark_value>MODE function</bookmark_value> 176<bookmark_value>most common value</bookmark_value> 177</bookmark><comment>mw added one entry</comment> 178<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODALWERT" id="bm_id3149253" localize="false"/> 179<paragraph xml-lang="en-US" id="hd_id3153933" role="heading" level="2" l10n="U" 180oldref="43">MODE</paragraph> 181<paragraph xml-lang="en-US" id="par_id3153085" role="paragraph" l10n="U" oldref="44"><ahelp hid="HID_FUNC_MODALWERT">Returns the most common value in a data set.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</paragraph> --- 181 unchanged lines hidden --- | 211<section id="mode"> 212<bookmark xml-lang="en-US" branch="index" id="bm_id3153933"><bookmark_value>MODE function</bookmark_value> 213<bookmark_value>most common value</bookmark_value> 214</bookmark><comment>mw added one entry</comment> 215<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MODALWERT" id="bm_id3149253" localize="false"/> 216<paragraph xml-lang="en-US" id="hd_id3153933" role="heading" level="2" l10n="U" 217oldref="43">MODE</paragraph> 218<paragraph xml-lang="en-US" id="par_id3153085" role="paragraph" l10n="U" oldref="44"><ahelp hid="HID_FUNC_MODALWERT">Returns the most common value in a data set.</ahelp> If there are several values with the same frequency, it returns the smallest value. An error occurs when a value doesn't appear twice.</paragraph> --- 181 unchanged lines hidden --- |