Count columns based on drop down select
I want to be able to have a sheet that lets me select items we make from a drop down list then check the components needs to make that item. Then have it multiply the materials needs by the number we want to fabricate and total the needed materials. After that I would like to have the sheet check our on hand materials from another sheet for stock and check a box if we have the materials on hand.
Appreciate any help, I am new to this and the formula I am trying to get to work seems complicated.
Help Article Resources
Check out the Formula Handbook template!