LEFT command with SUMIF

D

Duncan Help

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.
 
R

Roger Govier

Hi Duncan

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

Regards

Roger Govier
 
Top