Get instant live expert help on countif greater than 0
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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
I need a COUNTIF criteria that finds the number of entries that are "less than .1 but no greater than .2".
Solved by G. C. in 16 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