Multiple Condition SumProduct Ques.

  • Thread starter Thread starter LdoubleE80
  • Start date Start date
L

LdoubleE80

I'm trying to look up planned units by plant, by item type, by month
I made a table that looks like this

Col A COL B
ROW 1 JAN FEB
Plant A Item 1 5 10
Plant A Item 2 2 7

Plant B Item 1 10 8
Plant B Item 1 4 6

I have columns on other sheets that reference this table, and I want i
to say how many Item 1's are expected from Plant 1 in January...and s
on.

I've tried this.

==SUMPRODUCT(--($A$1:$A$50="PLANT A"),--($B$1:$B$50="ITE
1"),--(A1:N1="JAN"),$C$3:$N$45)

It's giving me "#value"

Thanks in advanc
 
Hi
for January use something like
=SUMPRODUCT(--(A1:A100="Plant A"),--(B1:B100="Item
1"),C1:C100)
 
Try this instead

=SUMPRODUCT(--($A$1:$A$50="Plant A"),--($B$1:$B$50="Item
1"),INDEX($A$1:$N$50,,MATCH("Jan",$A$1:$N$1,0)))

I'd strongly recommend that you use cells with your lookup criteria instead
of hard code them like "Plant Item and Month"

Not that this assumes that the months are not formatted dates but text
 
Back
Top