Help with counting formulas and exclusions

Iza Pieniadz
Iza Pieniadz ✭
edited 04/04/22 in Formulas and Functions

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!

Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Try this:


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

    thinkspi.com

Categories