How do I "count" the number of cells with a value in them? I have a
spreadsheet with 277 rows, but only some of these have data. I want to
find the "AVERAGE" of the cells with data. If I use the AVERGAE
function it uses the total number of cells (277) but some of these are
blank which skews the value. Thank in advance. So glad I found this
site. :)


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488409

Hi,

Use the COUNTA function.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=488409

Thank you. That works!


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=488409

AVERAGE function ignores blanks and non-numerics so the value is not skewed if
the blanks are truly blanks or are non-numerics.

Try it.

Enter numbers in A1:A10 and =AVERAGE(A1:A10) in A11

Insert 5 blank rows at A2:A6

The average returned is now =AVARAGE(A1:A16) and returns the same result.


Gord Dibben Excel MVP

On Sat, 26 Nov 2005 15:57:24 -0600, jimbob
wrote:


How do I "count" the number of cells with a value in them? I have a
spreadsheet with 277 rows, but only some of these have data. I want to
find the "AVERAGE" of the cells with data. If I use the AVERGAE
function it uses the total number of cells (277) but some of these are
blank which skews the value. Thank in advance. So glad I found this
site. :)