Counting Values in a Multi-Value Cell

Eli Rudnick

I'm trying to count single values in a cell with 29 other values and filter them by another multi-value cell. For example if "A" is among the selections in column X, and "Execution" is among the selections in column "Y" then that would be counted as 1 under the "Execution" column associated with row "A"

Paul Newcome

You would need to incorporate the HAS function.

=COUNTIFS({Source Sheet Column X}, HAS(@cell, [Primary Column]@row), {Source Sheet Column Y}, HAS(@cell, "Execution"))

Paul Newcome

You would need to incorporate the HAS function.

=COUNTIFS({Source Sheet Column X}, HAS(@cell, [Primary Column]@row), {Source Sheet Column Y}, HAS(@cell, "Execution"))