Sumif's Criteria Problem

[specs]

i tried sumif but seem to have a problem
e.g =SUMIF(A1:A3,"AJ",B1:B3)

A--------------B
_______________
AJ SMITH------2
MIKE GDE------1
AJ JOHNSON------3

is there anyway to have the the criteria matched rows1 and 3, which have a AJ word. so i can get the value of 5?

 

[Andrew Poulsom]

You can use a wildcard like this:

=SUMIF(A1:A3,"AJ*",B1:B3)

 

[specs]

Great, Thanks alot Andrew.