=SUMIF(B1:B5,"??Truck",A1:A5)

HTH
--
AP

"Ananth" a écrit dans le message de news:
...
A B
1 500 L-Truck
2 200 L-Car
3 150 T-Car
4 100 T-Truck
5 400 T-Truck

Using Sumif, is it possible to sum up only Car & Only Truck

I would like to see a total for Car as 350 & Truck 1000