COUNTIFS for single-select and multi-select columns

Paul Freudensprung

Hello,

I am trying to count the number of rows in a different sheet if they meet two conditions. One condition is contained in a Single-select column, the second argument is contained in a multiselect column in that sheet. I have looked through the community pages but have not been able to get a formula going:

=COUNTIFS({Different Sheet Range 2}, "Action", HAS({Different Sheet Range 1}, ColumnThisSheet@row))

Above the first range and criteria points to the single-select column, the second range to the multi-select column in a different sheet.

Any help is appreciated,

Thank you,

Paul

David Joyeuse

Hi @Paul Freudensprung

The range cannot be put into the HAS Function. Should be like this:

=COUNTIFS({Different Sheet Range 2}, "Action", {Different Sheet Range 1}, HAS(@cell, ColumnThisSheet@row))

Hope it helped!

David Joyeuse

Hi @Paul Freudensprung

The range cannot be put into the HAS Function. Should be like this:

=COUNTIFS({Different Sheet Range 2}, "Action", {Different Sheet Range 1}, HAS(@cell, ColumnThisSheet@row))

Hope it helped!

Paul Freudensprung

Thank you, David! Your suggestion indeed solved the issue!