View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RLD RLD is offline
external usenet poster
 
Posts: 11
Default SUMIF or SUMIFS help

I have 2 sheets in one workbook (Sheet 1 and Sheet 2)

Sheet 2 has 3 columns:
A B C
MAKE TYPE QTY

1 toyota compact 10
2 ford pickup 15
3 toyota sedan 20
4 toyota pickup 80
5 nissan hybrid 10

Sheet 1 has 2 columns:
A B
MAKE PICKUPS

1 toyota ? (SUM)

I need Sheet 1,B1 to calculate the total number of matching items in sheet 2
that matches the data entered in Sheet 1,A1. In other words, I need sheet
1,B1 to automatically sum up the total number of toyota pickups in sheet 2.
Can anyone help me with the formula to accomplish this?