sum formula

ADIB · Feb 16, 2009

Hi,
for instance

A B
arral bini 2000
rojar aoral 1500
arral d'costa 2000

i would like sum only name arral and it should be 4000. please suggest me
how can i make formula.
thanks

Gary''s Student · Feb 16, 2009

=SUMPRODUCT(--(LEFT(A1:A100,5)="arral"),(B1:B100))

ADIB · Feb 16, 2009

Thanks Gary

Gary''s Student said:
=SUMPRODUCT(--(LEFT(A1:A100,5)="arral"),(B1:B100))

Shane Devenshire · Feb 16, 2009

Hi,

Try:

=SUMIF(A1:A10,"arral*",B1:B10)

sum formula

ADIB

Gary''s Student

ADIB

Shane Devenshire