For some reason when i try to get an average for a particular column in
my sheet, it will only give me a #DIV/0 error. However, there are no
zeros in the column, and none of the cells in the column are linked
anywhere else that i can see. I've tried tracing precendents and have
found none.
I did notice that when i average another column (one that works
correctly) the "average window" (where I input my range) looks like
this:
=(3;4;5;6;7

but when I try to average the column that doesn't work, the "average
window" looks like this:
=("3";"4";"5";"6"

Can anyone tell me how to fix this?


--
waterwayz
------------------------------------------------------------------------
waterwayz's Profile: http://www.excelforum.com/member.php...o&userid=25001
View this thread: http://www.excelforum.com/showthread...hreadid=385269