Average Question

  • Thread starter Thread starter mikeeee
  • Start date Start date
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
 
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")
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

array to normal version formula 8
HIGHLIGHTING A COLUMN OF DATA 3
Copying format controls - xl2003 3
2 macro help 7
How to find average of selected cells and not include zero 1
Average Formula 1
Averaging a row & dividing by only the qty. of cells with a value 3
Average Formula Help 2

Back
Top