countif question

[Guest]

Hello,

trynig to count a range of cells if they start with a number,
the cells being counting countain data that will appear the following
format: #""## (1a14, 2a12, 3b14) when I used the count function I received
an error. How can I countif the cell begins with a number?

Thank You,
Brian

 

[Frank Kabel]

Hi
try the following formula
=SUMPRODUCT(--(ISNUMBER(-LEFT(A1:A100,1))))

 

[Guest]

Worked Perfect!
Thank You Frank

Hi
try the following formula
=SUMPRODUCT(--(ISNUMBER(-LEFT(A1:A100,1))))