Home » Forums » Open Source Learning Center » Question and Answer

I need a basic total sum that caps at 10000

Submitted by achtung_boy on 23 June, 2014 - 16:41

I have a column listing mileage that is tax deductible at 45pence per mile up to 10k. I have cell which totals the column, but would like it to stop at 10000, and I have a neighbouring cell that is already working out the pence per mile on the difference. If anyone could tell me how to create a normal sum function but cap it, I'd be grateful.

Thanks

‹ Macro for loss/gain per sale How to use the IF function to tally data ›
»

Hi

Submitted by Jon on 23 June, 2014 - 18:27.

Here, try this

assuming the numbers that need to be summed are in column D

=SUMIF(D:D,"<=" & "10000")

Hope this helps

»