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 |