| 04060106.xhp (cf7cf155) | 04060106.xhp (ae762a15) |
|---|---|
| 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 --- 967 unchanged lines hidden (view full) --- 976<paragraph xml-lang="en-US" id="hd_id3152110" role="heading" level="3" l10n="U" 977oldref="443">Example</paragraph> 978<paragraph xml-lang="en-US" id="par_id3152148" role="paragraph" l10n="CHG" oldref="626">To sum up only negative numbers: <item type="input">=SUMIF(A1:A10;"<0")</item> 979</paragraph> 980<paragraph xml-lang="en-US" id="par_id6670125" role="paragraph" l10n="NEW"> 981<item type="input">=SUMIF(A1:A10;">0";B1:10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0.</paragraph> 982<paragraph xml-lang="en-US" id="par_id6062196" role="paragraph" l10n="NEW">See COUNTIF() for some more syntax examples that can be used with SUMIF().</paragraph> 983</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 --- 967 unchanged lines hidden (view full) --- 976<paragraph xml-lang="en-US" id="hd_id3152110" role="heading" level="3" l10n="U" 977oldref="443">Example</paragraph> 978<paragraph xml-lang="en-US" id="par_id3152148" role="paragraph" l10n="CHG" oldref="626">To sum up only negative numbers: <item type="input">=SUMIF(A1:A10;"<0")</item> 979</paragraph> 980<paragraph xml-lang="en-US" id="par_id6670125" role="paragraph" l10n="NEW"> 981<item type="input">=SUMIF(A1:A10;">0";B1:10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0.</paragraph> 982<paragraph xml-lang="en-US" id="par_id6062196" role="paragraph" l10n="NEW">See COUNTIF() for some more syntax examples that can be used with SUMIF().</paragraph> 983</section> |
| 984<section id="Section15"> | 984<section id="Section64"> |
| 985<bookmark xml-lang="en-US" branch="index" id="bm_id3151957K"><bookmark_value>SUMIFS function</bookmark_value> 986<bookmark_value>adding;specified numbers</bookmark_value> 987</bookmark><comment>kschenk added one entry</comment> 988<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWNRNG" id="bm_id3151969K" localize="false"/> 989<paragraph xml-lang="en-US" id="hd_id3151957K" role="heading" level="2" l10n="U" 990oldref="436">SUMIFS</paragraph> 991<paragraph xml-lang="en-US" id="par_id3151986K" role="paragraph" l10n="U" ><ahelp hid="HID_FUNC_SUMMEWNRNG">Sum the values of cells in a range that meet multiple criteria in multiple ranges.</ahelp> 992</paragraph> --- 5 unchanged lines hidden (view full) --- 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> 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> | 985<bookmark xml-lang="en-US" branch="index" id="bm_id3151957K"><bookmark_value>SUMIFS function</bookmark_value> 986<bookmark_value>adding;specified numbers</bookmark_value> 987</bookmark><comment>kschenk added one entry</comment> 988<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUMMEWNRNG" id="bm_id3151969K" localize="false"/> 989<paragraph xml-lang="en-US" id="hd_id3151957K" role="heading" level="2" l10n="U" 990oldref="436">SUMIFS</paragraph> 991<paragraph xml-lang="en-US" id="par_id3151986K" role="paragraph" l10n="U" ><ahelp hid="HID_FUNC_SUMMEWNRNG">Sum the values of cells in a range that meet multiple criteria in multiple ranges.</ahelp> 992</paragraph> --- 5 unchanged lines hidden (view full) --- 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> 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 | |
| 1007<section id="Section14"> 1008<bookmark xml-lang="en-US" branch="index" id="bm_id3152195"><bookmark_value>TAN function</bookmark_value> 1009</bookmark> 1010<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TAN" id="bm_id3152207" localize="false"/> 1011<paragraph xml-lang="en-US" id="hd_id3152195" role="heading" level="2" l10n="U" 1012oldref="446">TAN</paragraph> 1013<paragraph xml-lang="en-US" id="par_id3152224" role="paragraph" l10n="CHG" oldref="447"><ahelp hid="HID_FUNC_TAN">Returns the tangent of the given angle (in radians).</ahelp></paragraph> 1014<paragraph xml-lang="en-US" id="hd_id3152242" role="heading" level="3" l10n="U" --- 413 unchanged lines hidden --- | 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" 1011oldref="446">TAN</paragraph> 1012<paragraph xml-lang="en-US" id="par_id3152224" role="paragraph" l10n="CHG" oldref="447"><ahelp hid="HID_FUNC_TAN">Returns the tangent of the given angle (in radians).</ahelp></paragraph> 1013<paragraph xml-lang="en-US" id="hd_id3152242" role="heading" level="3" l10n="U" --- 413 unchanged lines hidden --- |