Get instant live expert help on countif greater than zero

“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

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 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 to format computed cells with value greater than zero. Ive tried various conditions, none work
Solved by D. E. in 26 mins
NEED A FORMULA., IF THE VALUE IN L1 IS GREATER THAN ZERO THE VALUE IN H1 MUST CHANGE TO 0
Solved by A. A. in 19 mins
I need a formula to calculate, ifg8=zero then make e19 zero, but if e8 is greater than 1 then add up e13 to e19 and populate e19 with this total. Regards Louise
Solved by I. S. in 25 mins