COUNTIFS not working where one reference is a column with multiple drop downs...

nualamcd

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, "CASI")

This isn't working... I want a count for if the Priority is Critical (this is in [Column2]$28) and the Platform (from a drop down column) includes CASI. (There may be multiple entries in the drop down column). I know the answer is 1 but it's not returning that number...

HELP!!! Going mad here... 🤔

Paul Newcome

If you are using a multi-select dropdown, you will want to include a HAS function like so:

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, "CASI"))

Paul Newcome

If you are using a multi-select dropdown, you will want to include a HAS function like so:

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, "CASI"))

nualamcd

Awesome! Do I have to type each platform name or can I use a Column1@row code?

Paul Newcome

You can use cell references, but keep in mind that column names that have a special character, number, and/or space need to be wrapped in [square brackets].

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, [Column1]@row))

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, [Column Name]@row))

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, ColumnName@row))