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)
PERFECT! Thank you so much!!!!