Count if

[Jim]

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.

 

[Aladin Akyurek]

=COUNTA(A1:A6)

 

[Jack Sheet]

Would =COUNTA(A1:A6) function help?

 

[Max]

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