Thread: Count if

how do I write a count if formula to could a range of cells that can have any
data. For example if I want to count cell a1:a6 only if the cells have some
kind of data (numbers, letters, words, etc...)? Thanks for the help.

=COUNTA(A1:A6)

Jim wrote:
> how do I write a count if formula to could a range of cells that can have any
> data. For example if I want to count cell a1:a6 only if the cells have some
> kind of data (numbers, letters, words, etc...)? Thanks for the help.

Would =COUNTA(A1:A6) function help?

--
Return email address is not as DEEP as it appears
"Jim" <Jim@discussions.microsoft.com> wrote in message
news:9C48AC42-7449-43D9-ABA3-84C4CD255991@microsoft.com...
> how do I write a count if formula to could a range of cells that can have
> any
> data. For example if I want to count cell a1:a6 only if the cells have
> some
> kind of data (numbers, letters, words, etc...)? Thanks for the help.

Try in say, B1: =COUNTA(A:A)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Jim" <Jim@discussions.microsoft.com> wrote in message
news:9C48AC42-7449-43D9-ABA3-84C4CD255991@microsoft.com...
> how do I write a count if formula to could a range of cells that can have
any
> data. For example if I want to count cell a1:a6 only if the cells have
some
> kind of data (numbers, letters, words, etc...)? Thanks for the help.