Counting cells with data

[jimbob]

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.

[pinmaster]

Hi,

Use the COUNTA function.

HTH
JG

[jimbob]

Thank you. That works!

[Gord Dibben]

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
<[email protected]> 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.