Manuals/calci/SUMIF

From ZCubes Wiki
Revision as of 21:45, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> Syntax </div></div> ---- <div id="2SpaceContent" align="left"><div class="ZEditBox" align=...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Syntax

Examples

'''''''  ''''

Description

SUMIF

 

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

Column1 Column2 Column3 Column4
Row1 1000 100
Row2 9000 300
Row3 8000 250
Row4 12000 500
Row5 1050
Row6
'
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/SUMIF&oldid=613"