Two Level Lookup with Sum

  • Thread starter Thread starter TonyaT
  • Start date Start date
T

TonyaT

I have worksheet with 8-10 columns of data but only 3 are
used in this calculation. Column A has the plant name,
column B has the product name produced and column G has
the number of units produced. Can someone please provide
me a formula that will add all the units of
Product "Widget" by Plant name "A"
Thanks in advance - Tonya
 
Tonya,

=SUMPRODUCT((A1:A10="Plant Name")*(B1:B10="Widget")*(C1:C10))

Plant Name and Widget could also be cell references...

=SUMPRODUCT((A1:A10=G1)*(B1:B10=G2)*(C1:C10))

Dan E
 
Back
Top