Average Question

M

mikeeee

I am trying to get the average of a column say a1 to a300, a1 to a15
has a number in each cell but the rest of the cells are currently blan
but might have a number put in in the future. The problem I am having i
when I use the =average a1:a300 it gives me an error saying I a
dividing by zero. HELP!!!!

Once Again Thanks In Advance
Mik
 
F

Frank Kabel

Hi
this should only happen if none of the cell is filled. To prevent this
try.
=IF(COUNT(A1:A300),AVERAGE(A1:A300),"no data")
 
J

Jerry W. Lewis

Most likely, your "numbers" in A1:A155 are actually text that only look
like numbers. Copy a blank cell, and Edit|Paste Special|Add over the
range containing "numbers", then try using the AVERAGE() function.

Jerry
 
Top