Posting your formula helps. But I counted the number of
occurrences staring with "L" using:

=COUNTIF(A:A,"L*")

It's not an array formula. If the formula needs to be case-
sensitive, then try:

=SUMPRODUCT(--EXACT(LEFT(A1:A10),"L"))

Not an array formula either.

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm using an array formula to count occurrences of
certain text values in a
column. The column contains various 2-letter codes, and
I want to count the
number of occurrences of codes starting with "L". I've
tried using a wild
card character in the formula ("L?"), but it doesn't
work. THis approach
works fine for regular formulas, but I think there's
something to do with
Array formulas that prevents it from counting what I want.

Any suggestions out there?
--
PJB
.