COUNTIFS reference another sheet with multi-select dropdown and other criteria

Malissa M Alexander

I have built a sheet to count topics by referencing data on another sheet but have run into some hiccups where where a multi select dropdown is used.

I want to count the number of times a topic appears in a column where the criteria from two other columns are also specified.

{Type} is the sheet reference to a column with multi-select dropdown

=COUNTIFS({Type}, HAS(@cell, "Brand", {FQ} = "Q1", {FY} = "FY 2021"))

Everything about this formula works until I try to reference the multi-select dropdown column. What am I doing wrong here?

Jeff Reisman

@Malissa M Alexander

Looks to me like you've missed the close parentheses on the HAS function. You need a close parentheses after "Brand", and there's an extra close parentheses at the end of the formula. Also, you don't want to use the equal signs for text. The syntax calls for pairs of ranges and criteria with commas between the range, the criteria, the next range, the next criteria, etc. Try this:

=COUNTIFS({Type}, HAS(@cell, "Brand"), {FQ}, "Q1", {FY}, "FY 2021")

Malissa M Alexander

@Jeff Reisman Thank You!