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?
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?