LEFT command with SUMIF

[Guest]

I would like to use the LEFT command along with the SUMIF command, for
instance I would like to sum together the ABC of these rows.

A B
ABCX 10
ABCY 11
ABCZ 12

So I would like to sum together any time SUMIF finds the left 3 in column A
= ABC.

Thanks.

 

[JE McGimpsey]

One way:

=SUMIF(A:A,"ABC*",B:B)

 

[Roger Govier]

Hi Duncan

One way
=SUMPRODUCT(--(LEFT(A1:A3,3)="ABC"),B1:B3)

Regards

Roger Govier