Help with counting formulas and exclusions

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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!