Forum Discussion
SUMIF help
I need to create a formula where IF the sum of a range of cells exceeds a certain amount, THEN i need the sum of that range MINUS that certain amount. (in other words, if the total of the range of cells exceeds 10,000, I need to know the sum of that range of cells minus the 10,000. If the sum of the range of cells is less than 10,000, then I need it to display zero)
Could be like
=IF(SUM()>10000,SUM()-10000,0)
Could be like
=IF(SUM()>10000,SUM()-10000,0)
PERFECT! Thank you so much!!!!
Sergei,
Sorry to bother you again, but how could I do the following:
Couple similar scenarios
1-(if the sum of the range of cells exceeds 10,000, display the sum ABOVE 10,000, but if the sum of the range is less than 10,000, display the current sum of the range that is under 10,000)
2-if the sum of the range is is under 10,000, display the current sum of that range, but if the sum of the range exceeds 10,000, display 10,000)
Nevermind! Figured it out by playing with your other formula. Again, thank you so much!
