Re counting
opps.
I misunderstood your post. instead of countif, use sumif.
Regards
FSt1
"FSt1" wrote:
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
|