Multiple Condition SumProduct Ques.

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
 
F

Frank Kabel

Hi
for January use something like
=SUMPRODUCT(--(A1:A100="Plant A"),--(B1:B100="Item
1"),C1:C100)
 
P

Peo Sjoblom

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
 
Top