To sum column H where the value is less than 4

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

Regards

Trevor


"Joe" wrote in message
...
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?