Matching Multiple Criteria to Populate a Specific Result
I need to match data in (2) columns that will populate a result in a 3rd column.
Columns I need to match data in: Type Column and PS Qty Helper Column
If Type Column is "SM" and PS Qty Helper Column is "Dual", I need "PS Qty Dual + SM" to Populate "1", so that we can then count all of the lines that have "1" to know how many we have that are both SM and Dual.
Ultimately, we want this data to be on our Sheet Summary "PS Dual + SM"
Its entirely possible I am way overthinking this ... so if there is a better/easier way, please let me know!
My test sheet is here: https://app.smartsheet.com/b/publish?EQBCT=2a8f00cc49eb4021916f06af91e28095
Thanks in advance for the assist, and Happy Thanksgiving!
Help Article Resources
Check out the Formula Handbook template!