diff options
Diffstat (limited to 'source/text/scalc/01/04060106.xhp')
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 23 |
1 files changed, 1 insertions, 22 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 17ddd9643c..e10a68ae61 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -986,27 +986,7 @@ </section> <section id="Section15"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3151957"> - <bookmark_value>SUMIF function</bookmark_value> - <bookmark_value>adding;specified numbers</bookmark_value> -</bookmark> -<comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWENN" id="bm_id3151969" localize="false"/> - -<h2 id="hd_id3151957"><variable id="sumif_head"><link href="text/scalc/01/04060106.xhp#Section15">SUMIF</link></variable></h2> -<paragraph id="par_id3151986" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criterion.</ahelp> This function is used to sum a range when you search for a certain value.</paragraph> -<embed href="text/shared/00/00000001.xhp#regex"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range; Criterion [; SumRange])</paragraph> -<paragraph id="par_id3152043" role="paragraph" xml-lang="en-US"><emph>Range</emph> is the range to which the criterion is to be applied.</paragraph> -<embed href="text/scalc/01/ex_data_stat_func.xhp#criterion"/> -<paragraph id="par_id3152083" role="paragraph" xml-lang="en-US"><emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed.</paragraph> -<note id="par_id8347422">SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given.</note> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3152148" role="paragraph" xml-lang="en-US">To sum up only negative numbers: <item type="input">=SUMIF(A1:A10;"<0")</item></paragraph> -<paragraph id="par_id6670125" role="paragraph" xml-lang="en-US"><item type="input">=SUMIF(A1:A10;">0";B1:B10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0.</paragraph> -<paragraph id="par_id6062196" role="paragraph" xml-lang="en-US">See COUNTIF() for some more syntax examples that can be used with SUMIF().</paragraph> +<embed href="/text/scalc/01/func_sumif.xhp#func_sumif"/> </section> <section id="color"> @@ -1014,7 +994,6 @@ </section> <section id="sumifs"> - <h2 localize="false" id="hd_id72921259523046"><embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/></h2> <paragraph id="par_id131512822630259" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_des"/></paragraph> </section> |