Difference between revisions of "Manuals/calci/SUMIF"

Revision as of 12:36, 15 November 2013

SUMIF(a1:a4, c, R)

a1:a4 is the range of cells that you want evaluated by the given criteria.

C is the criteria in the form of a number, expression, or text

R are the actual cells to add

This function calculate the cells specified by a given criteria.

C1 C2

R1 1000 100

R2 9000 300

R3 8000 250

R4 12000 500

=SUMIF(C1R1:C1R4,">5000",C2R1:C2R4) is 1050

'

@@ Line 1: / Line 1: @@
 <div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify">
-<div id="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div>
-----
-<div id="11SpaceContent" align="left"><div class="ZEditBox mceEditable" align="justify">
-<font size="5">Description</font>
-</div></div>
-----
-<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman"> <font size="6">SUMIF</font> </font>'''</div></div>
-----
-<div id="3SpaceContent" class="zcontent" align="left"><br /><div id="7Space" class="gamizbox" title="7Space"><div id="7SpaceHeader" class="zheaderstyle" title="Double-click to start and stop editing the header."><center></center></div><div id="7SpaceRollup" title="Double-click to rolldown" align="left"><span><span id="7SpaceRollupContent" align="center"></span></span></div><div id="7SpaceCover"><div id="7SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify"><font size="3" face="Times New Roman"> </font>
 '''SUMIF'''(a1:a4, '''c''', R)