Multiple Condition SumProduct Ques.

[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

 

[Frank Kabel]

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

 

[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

 

[LdoubleE80]

I did what you suggested and I'm getting "N/A"