"Average" Formula Returns #DIV/0 error

Hi Tyler,

Check to see if you have TEXT instead of numbers that you are dealing with. Also instead of using the whole column A:A it is much better to use a defined number of rows, like A5:A500.

DIV/0 error means you are dividing by 0, When you copy paste, did you paste in the exact same location as well? being that all of your references are not absolute it is possible that it is trying to obtain values that may not be there.

Can you post a copy of this example - then we can take a look and make better suggestions. If it works in one it should work in the other, I would have to assume without seeing it that your references are to empty cells -

Or as Marvin pointed out, could be formatting...

Go Advance (ALT+X) and share a sample so we can see what is occurring.

I have looked at your file, (and its official, I dont like google docs lol).

Be that as it may, I would suggest that you change the formulas like this 1...
=if(sum(D7:D13)>0,sum(D7:D13),"-")
to just this...
=sum(D7:D13)
my reason for suggesting this, if that with all those "-" in the column, doing further calcs could be troublesome

Also, I would advise against merging cells like you have, merging causes all sorts of problems with calcs

Finally, you are getting #Div/O for that very good reason, you have no data to average. Try using IFERROR() to trap that