SumIF statements

Benz9 · Oct 17, 2003

please help...

i am trying to create a formula to add only if the
previous cell is greater than or equal to 8.

Guest · Oct 17, 2003

A1:A10 lookup range
B1:B10 values to be added
C1=8

=SUMIF($A$1:$A$10,">="&C1,$B$1:$B$10)

Benz9 · Oct 17, 2003

Thanks, much help

-----Original Message-----

A1:A10 lookup range
B1:B10 values to be added
C1=8

=SUMIF($A$1:$A$10,">="&C1,$B$1:$B$10)

.