Re counting
For those who don't like SUMPRODUCT, try this
=SUMIF(B1:B5,"AA",A1:A5)+SUMIF(B1:B5,"AB",A1:A5)
This may be more efficient for a large range.
Epinn
"Epinn" wrote in message ...
If I understand you correctly ......
In C1: =SUMPRODUCT((B1:B5="AA")+(B1:B5="AB"),A1:A5)
This formula returns 12 which is the sum of 7 (for AA) and 5 (for AB).
For Excel 2003, SUMPRODUCT does not work on columns i.e. A:A or B:B.
If you want to see 7 in one cell and then 5 in another, use SUMIF.
Epinn
"pano" wrote in message ups.com...
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
|