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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index match to return all values 13
Scrabble Value calculation for Welsh words 0
sum product with criteria from 2 wkshts 3
match?? 1
sumproduct using criteria from 2 worksheets 1
sumproduct using criteria from multiple columns in a separate wksh 1
Lookup and Change Values 3
Ifsumproduct 1

Back
Top