Using COUNTIF with LEFT() 2

[MeGustaXL]

Hiya,

I have several rows of data like this:

C9 C9 C9 9 9 C9 9 9 C9 3 9 9 9 9 9 9 9 9

I want to know how many cells begin with 'C' - I've tried =COUNTIF(LEFT(A1:A18,1)="C")), entered as an array formula, but that doesn't work.

What's the correct syntax for this?

Chris

Someday I'll know what I'm donig...damn!

 

[mintjulep]

Countif supports wildcards.

=COUNTIF(Range,"C*")

as a regular formula should do it.

 

[SkipVought]

Try this instead...
[tt]
=SUMPRODUCT(--(LEFT(A1:A18,1)="C"))
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MeGustaXL]

Hey Thank you guys!

Both star-worthy answers ===>*

Mintjulep for being so blindingly obvious and simple [D'OH] and Skip for sending my mind down ever-increasing levels of functionality for this sheet, and answering my next question, before I even asked it!

Chris

Someday I'll know what I'm donig...damn!

 

[SkipVought]

I musta had Miss Voyant with me, as I often talk with Clair. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}