Re: Re counting

Tech-Archive recommends: Speed Up your PC by fixing your registry

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" <jenawyn@xxxxxxxxxxxxxxx> wrote in message news:1170554402.604455.47090@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages