SUMIF problem

[saa]

Hi.

I have a list of data like this:
TPM6 1,605
HCK6 102
RLM6 -561
SPM6 1,480

And I want to map these to a list like this:
TP
RL
SP
HC

The two last positions in the first column will change over time (i.e.
TPM6 will change to TPZ6 etc.) and I might experience more entries with
TP as the first two letters.

My initial thought was that I need the function SUMIF, but I can't seem
to find a nice way to only search on the first two letters. I tried to
insert a column to the left, where I use LEFT(<ref>,2) and so I have a
list to use, but I was hoping there would be a nicer way.

Regards
Søren.

 

[Bondi]

Hi,

Maybe you can use something like:

=SUMPRODUCT(--(LEFT(A1:A4,2)="TP"),B1:B4)

Regards,
Bondi