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
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!