View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RLD RLD is offline
external usenet poster
 
Posts: 11
Default IFSUM and IFSUMS - which to use and how

I have 2 sheets. They are as follows:

Sheet1:
A B C
1 Make Type Qty
2 Toyota Hybrid 20
3 Ford Hybrid 68
4 Nissan Sedan 95
5 Toyota Hybrid 11
6 Dodge Truck 15
7 Toyota Sedan 21
8 Ford Sedan 0

Sheet2:
A B C
1 Make Qty Hybrids Qty Sedans
2Toyota
3 Ford

I need B2 and C2 of Sheet2 to sum up the total number of matching data from
Sheet1. In other words, how do I get Sheet2 B2 to sum up the total number of
Toyota Hybrids in Sheet 1?