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
|