Get instant live expert help on I need help with excel average if not 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
I need a formula that will average cells e3:h3 if the cell is greater than 0 if not then leave it blank
Solved by G. Q. in 25 mins
I NEED A AVERAGE FORMULA IN EXCEL =AVERAGE(G3:G11) THE RESULT "#DIV/0!" WHAT IS THIS? IF MY BETWEEN G3-G11 IF THERE IS NUMBER ONLY IN 1 CELL THEN ALSO IT SHOWING THE RESULT BUT IF ALL THE CELL ARE EMPTY THEN THE OUTPUT IS ""#DIV/0!"
Solved by A. J. in 22 mins
I need a formula to find the average of two cells if both cell values are greater than 0. If one cell value is 0, no average is needed. Example: A1 = 50, B1 = 50, C1 = 25 A1 = 50, B1 = 0, C1 = 50
Solved by E. F. in 16 mins
I want to getting average of last 365 entries in a column, this will be a "rolling" average as a new entry will be added to the bottom of the column each day. This formula works: =AVERAGE(OFFSET(C10,COUNT(C11:C255),0,-244)) The catch is if there is a 0 in cells I do not want it figured in.
Solved by B. D. in 20 mins
I need to set an average that IF a record is 0 to ignore that #
Solved by E. D. in 21 mins