how to use sumif

J

Joe

I have a spreadsheet that has data in it. I need to sum it all up, but
anything over a certain number, I want it to stop, but still be able to keep
up with the data. Just the sum needs to stay at that number or below...any
suggestions?
 
T

Trevor Shuttleworth

To sum column H where the value is less than 4

=SUMIF(H:H,"<"&4,H:H)

Regards

Trevor
 
S

Sloth

Use the MIN function

=MIN(SUM(A1:A100),500)

This will sum A1:A100, and if the sum is greater than 500 the formula will
output 500 instead.
 
Top