COUNTIF

[ipsdan]

I want to calculate the number of times there is a cell contains some data i.e. is not blank within a range. I should know but I don't, any help appreciated.

 

[howzat]

Hi there,

Try =COUNTA(range)

 

[hattster]

You could also try
=COUNTIF(range)"<>"
This should eliminate all blanks

 

[shades]

=COUNTIF(range),"<>")

 

[Zack Barresse]

How about just ..

=COUNTBLANK(A1:A10)
for blanks.

=COUNTA(A1:A10)
for text/numbers.

=COUNT(A1:A10)
for numbers only.