Forum Discussion
Using the right functions
It looks like you're using google sheets. I can't remember if Sumproduct() works the same way in that software.
Try this:
=C2-SUMPRODUCT((EXPER!$D$2:$D$16="Plastic4078")*EXPER!$E$2:$F$16)
or this:
=C2-SUMPRODUCT((EXPER!$D$2:$D$16="Plastic4078"),(EXPER!$E$2:$F$16))
or this:
=C2-IF(EXPER!D2="Pastic4078", Sum(EXPER!E2:F2),0)
Hey Mike-
Hope that you're doing well. Maybe try something like this:
If this isn't quite what you're looking for maybe you can modify my attached example workbook to reflect your data structure. Not sure I comprehend what the data looks like exactly. Sounds like it will be a quick fix though:
- Thanks Matt for the response.
I have inserted a few photos of the spreadsheets.
- When Material (Column D) = "Plastic4001" then deduct E and F on that row from I2 (other spreadsheet)
Thank-you for your time It looks like you're using google sheets. I can't remember if Sumproduct() works the same way in that software.
Try this:
=C2-SUMPRODUCT((EXPER!$D$2:$D$16="Plastic4078")*EXPER!$E$2:$F$16)
or this:
=C2-SUMPRODUCT((EXPER!$D$2:$D$16="Plastic4078"),(EXPER!$E$2:$F$16))
or this:
=C2-IF(EXPER!D2="Pastic4078", Sum(EXPER!E2:F2),0)
Matt,
It Worked!!!
=C2-SUMPRODUCT((EXPER!$D$2:$D$16="Plastic4078")*EXPER!$E$2:$F$16)
One last question...
The last step...
I have multiple tabs that the Inventory Spreadsheet is pulling from.
The Spreadsheet itself is the same except the info that is entered in the specific columns.
In other words EXPER! is one tab that it pulls from but also EXPER1! and EXPER2! ,and so forth.
It works perfectly but how do you incorporate the other tabs?
You've been a great help... I have spent hours on Excel help and YouTube trying to figure this out.
