 # Get instant live expert help on average if not 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

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