Excel formula problem

[paw]

Hello all,

This is a formula and error message issue and I am at my wits end.

I am putting in some test grades and trying to get the average of each test (or column). The average formula has worked up to the last 3 columns. Now I am getting this message: #DIV.0! Everybody didn't take every quiz so some cells are empty. But the cells that worked have empty cells in their rows also. I have formatted the cells as numbers and also as general. Still these last 3 columns don't work. Does anyone have any ideas. I would be most greatful.

Thanx

paw

 

[Dreamboat]

Sorry to take so long.
Just got home.
Okay...I can't fix the darn file. Honestly, I think it's just corrupt.
I selected all cells and copied.
New workbook.
Edit-Paste special, choose Values.

Select all your number cells and format as number with the number of decimals you want.

I performed average functions on them, and it worked just fine.

I don't get what's wrong with the file otherwise.

Anne Troy

http://www.VBAExpress.com

 

[paw]

Dreamboat/Anne,

Thanks so much for your help. I did the thing over from scratch while you were at the doctor's. But I also did what you suggested just to see if it would work for me and it did.

Thanks again,

paw

 

[Dreamboat]

Yeah.

PAW, that file was a weirdo. Don't be expecting to have to fix more than perhaps one other file that way in your lifetime.

Glad it worked tho.

Anne Troy

http://www.VBAExpress.com