Matching Multiple Criteria to Populate a Specific Result

Nancy Heater

Hello!

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!

Mark Cronk

Hi @Nancy Heater,

I entered the formula below in your test sheet. Is that what you're looking for?

=IF(AND(Type@row = "SM", [PS Qty Helper Column]@row = "Dual"), 1, 0)

Mark

Mark Cronk

Hi @Nancy Heater,

I entered the formula below in your test sheet. Is that what you're looking for?

=IF(AND(Type@row = "SM", [PS Qty Helper Column]@row = "Dual"), 1, 0)

Mark

Nancy Heater

@Mark Cronk ... I think so, but when I'm trying to now count all of the instances of "2" in that column for my Sheet Summary, its saying #UNPARSEABLE.

I feel like there should be an "easier" way to do this, perhaps.

Is it possible to do a COUNTIF based off of (2) matching columns for the Sheet Summary data, without having to create all these other columns to get the end result?

Example ... Count number of lines that have both PS Qty of 2 and Type of SM?

Nancy Heater

Got it to work - thanks!