Countif function

[Daniel Bonallack]

I'm sure this is as easy as falling off a log for most of
you...

How can I count how many entries in a column begin with
the letter "A"?

Thanks in advance.

Daniel

 

[Andy B]

Daniel

Try this
=COUNTIF(A1:A100,"a*")
Adjust cell ref as required.

Andy

 

[Anon]

I'm sure this is as easy as falling off a log for most of
you...

How can I count how many entries in a column begin with
the letter "A"?

Thanks in advance.

Daniel

One way:
=SUMPRODUCT((LEFT(A1:A100,1)="A")*1)

 

[daniel.bonallack]

Thanks!

-----Original Message-----
Daniel

Try this
=COUNTIF(A1:A100,"a*")
Adjust cell ref as required.

Andy



.