Get instant live expert help on I need help with excel sumif greater than 0

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

If a calculated cell is less than 0 = 0, if the same cell is greater that 0 that multiplied by 12 a1:a4 if greater than zero a5 x 12 if a5 is less than 0 = 0
Solved by G. H. in 21 mins
if K2 is less than 0, then I2. But if greater than 0, then K2(or leave as it is)
Solved by E. S. in 26 mins
If cell f16 is greater than 0 them multiply the total by 102 and subtract 127.5.
Solved by B. Y. in 16 mins
=IF(AND(D11>0,F11>0)(D11^2+F11^2)^.5)0) if cell D11is greater than 0 AND F11> 0 then D11^2+F11^2)^.5)0 else 0
Solved by S. A. in 27 mins
I'm trying to get a count of the difference where the difference is greater than and less than in column E. I tried an if, then using greater than 0 but it's not working properly for me.
Solved by T. D. in 27 mins