Difference between revisions of "Manuals/calci/SUMIF"
Jump to navigation
Jump to search
'
(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=...") |
|||
| Line 1: | Line 1: | ||
<div id="16SpaceContent" align="left"><div class="ZEditBox" align="justify"> | <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="8SpaceContent" align="left"><div class="ZEditBox" align="justify">'''<font face="Times New Roman">''''''''''''<font size="6"> </font>''' '''''''''</font>'''</div></div> | ||
---- | ---- | ||
Revision as of 12:35, 15 November 2013
''''''' ''''
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 |