Forum Discussion
Solved
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 c...
Could be like
=IF(SUM()>10000,SUM()-10000,0)
Could be like
=IF(SUM()>10000,SUM()-10000,0)
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!
PERFECT! Thank you so much!!!!
