a function that counts the amount of cells with information in them

[zuri125]

Is there such a function that counts the amount of cells wit
information in them. For example right now Im trying to find this so
can find an average. So Im wanting to divide the autosum by the numbe
of cells with information. The numbers that make up the autosum hav
blank cells in between them, so i cant just count the number of cells
i need the number of cells with information on them.
I hope you understand what Im asking for. Tell me if u want me t
explain more.
Thank

 

[DoctorWard]

If you use the following formula it will achieve the result you want

a) =sum(RANGE) - will sum the data you have
b) =count(if(isblank(RANGE),1)) - needs to be set as an array so onc
you have written the formula instead of pressing Enter press CTRL
SHIFT + ENTER all at once

Divide (a) by (b) to acheive your average

Cheers
D

 

[Peo Sjoblom]

=sum(a1:a10)/count(A1:A10)



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey