software

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?

To sum column H where the value is less than 4

=SUMIF(H:H,quot;lt;quot;amp;4,H:H)

Regards

Trevorquot;Joequot; gt; wrote in message
...
gt;I have a spreadsheet that has data in it. I need to sum it all up, but
gt; anything over a certain number, I want it to stop, but still be able to
gt; keep
gt; up with the data. Just the sum needs to stay at that number or below...any
gt; suggestions?
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.

quot;Joequot; wrote:

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