COUNTIFS not counting as expected

HalfSun

I want to create a vendor comparison chart and for that I want to show each vendor, and the number of requirements they meet, but I also have some of those requirements that are "Must haves" and so I want to show those separately. I have 2 columns that are checkboxes - one for "MUST have:" and one for "Feature - Yes/No" (if checked, the vendor meets that criteria).

In another column I have this formula:

=COUNTIFS([MUST have:]@row = 1, [Feature - Yes/No]@row = 1)

Which I would expect to count only if a row meets the criteria that the checkbox in BOTH columns for that row are checked. Instead it is counting only if the "MUST have" column in that row is checked.

What do I need to change to make it consider both?

EDIT: I figured it out! I changed it to:

=COUNTIFS([MUST have:]@row, 1, [Feature - Yes/No]@row, 1)

Then it worked.

Georgie

Hi @HalfSun,

Glad you were able to work this out! Thanks for coming back and editing your post to help other members! 😊

Georgie