hi,
one way....
=countif(A1:A5000,"AA")
I think I would use a sperate formula of the AB part.

Regards
FSt1

"pano" wrote:

Hi, wonder if you can help

In A1 I have a number in b1 I have two letter. All going downwards

A1 B1

5 AA
3 AB
2 AA
empty empty
2 AB

I would like to be able to count in C1 the total of AA (7) and the
total of AB(5) bearing in mind that some cells will be empty.


Thanks for the help
Regards Stephen