Thread: Sumif
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ananth Ananth is offline
external usenet poster
 
Posts: 51
Default Sumif

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