Count non blank cells

[hsandeep]

I get values in a column R (R18:R9999) which are either

1. values (alphabets, numericals or alphanumericals) or
2. null "" throgh formula.

How to count no. of cells where values (serial no. 1) appear?
Please someone help.

 

[hsandeep]

T.Valko,
Can you explain ?* in your formula. please i will also learn a little........

 

[T. Valko]

T.Valko,
Can you explain ?* in your formula. please i will also learn a little........

Consider this sample data...

Book1
	A
2	1
3	x
4	_
5	_
6	#N/A
Sheet1

Cell A4 contains a formula blank "" and cell A5 is EMPTY.

This formula returns the correct count of 2:

=COUNTIF(A2:A6,"?*")+COUNT(A2:A6)

The ?* are wildcards. This means count cells that start with any TEXT character followed by any other TEXT character(s) or no TEXT character(s) at all.

 

[hsandeep]

Sir,
nice to know about ?*. But will it take care of values appearing like M429 in the column?
Here it starts with any TEXT character (M) followed by any other TEXT character(s) or no TEXT character(s) at all. 429 is not text character?