Help with counting formulas and exclusions

Iza Pieniadz

Hi there,

I'm trying to create a formula that would count all instances where a certain option is selected from a Multi-select drop-down and then it would subtract any instances if a certain category has been selected in another column. For example:

This formula gives me 13 counts:

=COUNTIFS([Curatorial Department]:[Curatorial Department], HAS(@cell, "Arts of Africa"))

I then need to subtract any instance that has been identified as a "Tour" from my Type column

Any ideas what that formula could like like? Thanks in advance!

Paul Newcome

Try this:

=COUNTIFS([Curatorial Department]:[Curatorial Department], HAS(@cell, "Arts of Africa"), Type:Type, @cell <> "Tour")