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!
0
Answers
-
Try this:
=COUNTIFS([Curatorial Department]:[Curatorial Department], HAS(@cell, "Arts of Africa"), Type:Type, @cell <> "Tour")
thinkspi.com
0