Get instant live expert help on sum if 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
I need a formula that states if Cell C contains 0 then Cell D = 0 but if Cell C contains any number greater than 0 then Cell D will equal the sum of Cells A and B
Solved by V. S. in 12 mins
I need a formula that will tell me the sum of cells that have a greater value than 0. Not the sum of the numbers in the cells but if its used =1 not used= 0 kind of sum.
Solved by M. U. in 20 mins
I have a problem regarding to Sum if greater than
Solved by C. F. in 12 mins
I need a formula that will say: IF b3/g3 = less 1% then state <1 if greater than <1 then state sum of b3/g3 if zero then state 0
Solved by D. W. in 25 mins