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" wrote in message
...
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 <atyahoo<dotcom
----
"Jim" wrote in message
...
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.