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

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