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
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