Average

[That's Confidential]

I am trying to work out the average of the numbers in a column and so have
entered the following formula

=AVERAGE(A1:40)

This however does not work for me. I only want it to work out the average if
there is a value in the cells in the column. As it stands now, I am entering
a few values between 1 - 5 in the cells in column A, however as I am missing
out some cells out too, I am ending up with a figure of 0.80.

So, how do I work out the average of the values of cells in a column,
excluding cells within that column with no data in them?

Thanks

 

[JE McGimpsey]

AVERAGE() ignores cells with no data already...

 

[Gary Hunt]

Try using the avergea function rather than the average.
also make sure that the cells you have entered the numbers
into are set to number
do this by highlighting them and then pressing the right
mouse button select the number tab then the number option,
you should also set the number of decimal places you want
it set to.
this should solve it for you.

all the best

Gary Hunt

=AVERAGEA('Draw Data'!a2:a40