Selective summing of table items?

J

John

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
 
R

RagDyer

Try this:

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

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