Help with counting formulas and exclusions
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
Check out the Formula Handbook template!