ExcelBanter - how to use sumif

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to use sumif (https://www.excelbanter.com/excel-discussion-misc-queries/74692-how-use-sumif.html)

Joe

how to use sumif

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?

Trevor Shuttleworth

how to use sumif

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?

Sloth

how to use sumif

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.

"Joe" wrote:

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?

All times are GMT +1. The time now is 08:59 AM.