COUNTIFS OR - unparsable, please help
The formula below is receiving an unparsable error. Can someone help me figure out how to fix it?
What I'm trying to do:
I need to count all the email options for the XYZ Business Group. Email could include "Email - Outlook", "Email - Poppulo" and "Yammer Announcement". The email types would be contained in the "Channels / Media Type" column, however, I only want to count those for the XYZ business group. The business group is indicated in the "Business Group" column.
Formula:
=COUNTIFS([Business Group]:[Business Group], "XYZ", Channels / Media Type:Channels / Media Type, OR(CONTAINS("Email", @cell), CONTAINS("Yammer Announcement", @cell)))
Any help would be greatly appreciated! Thanks in advance!!!!
Best Answer
-
Looks like it's just missing the brackets around the "Channels / Media Type]:[Channels / Media Type"
=COUNTIFS([Business Group]:[Business Group], "XYZ", [Channels / Media Type]:[Channels / Media Type], OR(CONTAINS("Email", @cell), CONTAINS("Yammer Announcement", @cell)))
Answers
-
I think the formula looks pretty good on its face. Could it be that your column name doesn't have brackets around it? Maybe like this?
=COUNTIFS([Business Group]:[Business Group], "XYZ", [Channels / Media Type]:[Channels / Media Type], OR(CONTAINS("Email", @cell), CONTAINS("Yammer Announcement", @cell)))
-
Looks like it's just missing the brackets around the "Channels / Media Type]:[Channels / Media Type"
=COUNTIFS([Business Group]:[Business Group], "XYZ", [Channels / Media Type]:[Channels / Media Type], OR(CONTAINS("Email", @cell), CONTAINS("Yammer Announcement", @cell)))
-
Thank you @Devin Lee !!!!! 😎
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!