View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John
 
Posts: n/a
Default Selective summing of table items?

How do I write a function to sum the all the quatities in the item table
named named "Table" B2:C7 that match the product name in cell named "Product"
A1?
a b c
1 prodx
2 Item Quan
4 prodx 100
5 prodx 200
6 prody 20
7 prodz 40
8 prodx 100