“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 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 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 help to get rid of #DIV/0! in a spreadsheet where I am using the following formula:
=AVERAGE(DF34,DI34,DL34,DO34,DR34,DU34,DX34)
If there are no numbers in the specified cells, this formula is returning the value of #DIV/0! and I would like to have it either be 0 or blank.
I have tried the IF and IFERROR function but am not placing this IF formula in the correct position to the =AVERAGE function.
Please HELP!!

Solved by T. Q. in 22 mins