sum formula

[ADIB]

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]

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

 

[ADIB]

Thanks Gary

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

 

[Shane Devenshire]

Hi,

Try:

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