Formula Help

Amy Shank

I would like a formula that counts the # of entries that are marked for the event "Non-Public Schools Leadership Conference" that contain an admission item marked "Exhibitor" whose payment method is not marked "Free". What am I doing wrong in the formula below?

=COUNTIFS([Event Title]:[Event Title], "Non-Public Schools Leadership Conference", [Admission Item]:[Admission Item], (OR(@cell = "Exhibitor", [Payment Method]:[Payment Method], (OR(@cell <>"Free")))

Neil Egsgard

@Amy Shank , you can't use OR statements inside COUNTIFS and @cell has to be in a function like HAS that is referring to each cell in a specific range. Try this:

=COUNTIFS([Event Title]:[Event Title], "Non-Public Schools Leadership Conference",  [Admission Item]:[Admission Item], "Exhibitor", [Payment Method]:[Payment Method], <>"Free")

What are the column types for Event Title, Admission Item, and Payment Method?

Neil Egsgard
Business Solutions Architect
Southern Alberta Institute of Technology