Manuals/calci/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

'

---