Difference between revisions of "Manuals/calci/SUMIF"
Jump to navigation
Jump to search
'
| Line 8: | Line 8: | ||
'''R''' are the actual cells to add | '''R''' are the actual cells to add | ||
| − | |||
C1 C2 | C1 C2 | ||
| Line 19: | Line 18: | ||
R4 12000 500 | R4 12000 500 | ||
| + | |||
<nowiki>=SUMIF(C1R1:C1R4,">5000",C2R1:C2R4) is 1050</nowiki> | <nowiki>=SUMIF(C1R1:C1R4,">5000",C2R1:C2R4) is 1050</nowiki> | ||
</font></font></div></div> | </font></font></div></div> | ||
| + | |||
---- | ---- | ||
<div id="1SpaceContent" class="zcontent" align="left"><div> | <div id="1SpaceContent" class="zcontent" align="left"><div> | ||
Revision as of 11:38, 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
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 |