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

Try this:

=SUMIF(B2:B7,A1,C2:C7)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"John" wrote in message
...
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

=SUMIF(B4:B8,A1,C4:C8)

- John