Forum Discussion
Solved
Using the right functions
I am creating an inventory spreadsheet (Inventory)using info from another tab(Production). Basically, anytime the word "Plastic1048" is in D column it should subtract the production and scrap in tha...
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
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