| 04060106.xhp (ae762a15) | 04060106.xhp (f1ce4842) |
|---|---|
| 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 --- 985 unchanged lines hidden (view full) --- 994<paragraph xml-lang="en-US" id="hd_id3152015K" role="heading" level="3" l10n="U">Syntax</paragraph> 995<paragraph xml-lang="en-US" id="par_id3152028K" role="code" l10n="U">SUMIFS( Reference R ; Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph> 996<paragraph xml-lang="en-US" id="par_id3152043K" role="paragraph" l10n="U">Sums the value of cells in range R that meet the Criterion C1 in the reference range R1, and the Criterion C2 in the reference range R2, and so on. </paragraph> 997<paragraph xml-lang="en-US" id="par_id3152062K" role="paragraph" l10n="CHG" >A <emph>Criterion</emph> is a single cell Reference, Number or Text. If the criterion is written into the formula, it has to be surrounded by double quotes.</paragraph> 998<paragraph xml-lang="en-US" id="par_id3152083K" role="paragraph" l10n="U">All <emph>Reference</emph> ranges shall have the same dimension and size, else an Error is returned.</paragraph> 999<!--<paragraph xml-lang="en-US" id="par_id8347422K" role="note" l10n="NEW">SUMIFS supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given.</paragraph>--> 1000<paragraph xml-lang="en-US" id="hd_id3152110K" role="heading" level="3" l10n="U" 1001oldref="443">Example</paragraph> | 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 --- 985 unchanged lines hidden (view full) --- 994<paragraph xml-lang="en-US" id="hd_id3152015K" role="heading" level="3" l10n="U">Syntax</paragraph> 995<paragraph xml-lang="en-US" id="par_id3152028K" role="code" l10n="U">SUMIFS( Reference R ; Reference R1 ; Criterion C1 [ ; Reference R2 ; Criterion C2 ]... )</paragraph> 996<paragraph xml-lang="en-US" id="par_id3152043K" role="paragraph" l10n="U">Sums the value of cells in range R that meet the Criterion C1 in the reference range R1, and the Criterion C2 in the reference range R2, and so on. </paragraph> 997<paragraph xml-lang="en-US" id="par_id3152062K" role="paragraph" l10n="CHG" >A <emph>Criterion</emph> is a single cell Reference, Number or Text. If the criterion is written into the formula, it has to be surrounded by double quotes.</paragraph> 998<paragraph xml-lang="en-US" id="par_id3152083K" role="paragraph" l10n="U">All <emph>Reference</emph> ranges shall have the same dimension and size, else an Error is returned.</paragraph> 999<!--<paragraph xml-lang="en-US" id="par_id8347422K" role="note" l10n="NEW">SUMIFS supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given.</paragraph>--> 1000<paragraph xml-lang="en-US" id="hd_id3152110K" role="heading" level="3" l10n="U" 1001oldref="443">Example</paragraph> |
| 1002<paragraph xml-lang="en-US" id="par_id3152148K" role="paragraph" l10n="CHG">Sum up cells in range A1:10 if the entires in B1:B10 are positive, and the entries in D1:D10 are the letter "A": <item type="input">=SUMIFS(A1:A10;B1:B10;">0";D1:D10;"A")</item> | 1002<paragraph xml-lang="en-US" id="par_id3152148K" role="paragraph" l10n="CHG">Sum up cells in range A1:10 if the entries in B1:B10 are positive, and the entries in D1:D10 are the letter "A": <item type="input">=SUMIFS(A1:A10;B1:B10;">0";D1:D10;"A")</item> |
| 1003</paragraph> 1004<paragraph xml-lang="en-US" id="par_id6062196K" role="paragraph" l10n="NEW">See COUNTIFS() for some more syntax examples that can be used with SUMIFS().</paragraph> 1005</section> 1006<section id="Section14"> 1007<bookmark xml-lang="en-US" branch="index" id="bm_id3152195"><bookmark_value>TAN function</bookmark_value> 1008</bookmark> 1009<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAN" id="bm_id3152207" localize="false"/> 1010<paragraph xml-lang="en-US" id="hd_id3152195" role="heading" level="2" l10n="U" --- 416 unchanged lines hidden --- | 1003</paragraph> 1004<paragraph xml-lang="en-US" id="par_id6062196K" role="paragraph" l10n="NEW">See COUNTIFS() for some more syntax examples that can be used with SUMIFS().</paragraph> 1005</section> 1006<section id="Section14"> 1007<bookmark xml-lang="en-US" branch="index" id="bm_id3152195"><bookmark_value>TAN function</bookmark_value> 1008</bookmark> 1009<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAN" id="bm_id3152207" localize="false"/> 1010<paragraph xml-lang="en-US" id="hd_id3152195" role="heading" level="2" l10n="U" --- 416 unchanged lines hidden --- |