Is it possible to divide countifs formulas

I'm trying to divide countifs formulas that are using two criterias! I've gotten it to produce a number, but the resulting number is incorrect!!

I want to find the % of 'Yes' values in the Opened For field, for the Contact & Support Team. So

#of Customer & Support Opened for' Yes / Total #of Customer & Support 'Opened for' for

This is the formula that is delivering the incorrect %

=COUNTIFS([Opened For (populated with accurate EE name)]:[Opened For (populated with accurate EE name)], "Yes", Team:Team, ="Contact & Support") / COUNT([Opened For (populated with accurate EE name)]:[Opened For (populated with accurate EE name)], Team:Team, ="Contact & Support")

Find more posts tagged with

Accepted answers

Nick Korna

@AGorgei

This should do the trick if you're after the %age of "Yes"' from the Contact & Support team:

=COUNTIFS([Opened For (populated with accurate EE name)]:[Opened For (populated with accurate EE name)], "Yes", Team:Team, "Contact & Support") / COUNTIFS(Team:Team, "Contact & Support")

If you're wanting the %age for Yes AND Contact & Support as a total of all lines:

=COUNTIFS([Opened For (populated with accurate EE name)]:[Opened For (populated with accurate EE name)], "Yes", Team:Team, "Contact & Support") / COUNTIFS([Opened For (populated with accurate EE name)]:[Opened For (populated with accurate EE name)], <>"")

Let me know if there are any problems/questions!

All comments

Jason Albrecht

Hi @AGorgei

maybe try this?

=COUNTIFS([Opened For (populated with accurate EE name)]:[Opened For (populated with accurate EE name)], "Yes", Team:Team, ="Contact & Support") / COUNTIFS([Opened For (populated with accurate EE name)]:[Opened For (populated with accurate EE name)], Team:Team, ="Contact & Support")

It looks like the 2nd CountIFS function was missing the IFS?

AGorgei

Hi @Jason Albrecht thanks, I tried that one before too...getting an #Invalid Operation error. I've also tried the second Count as as COUNTIF and that throws a #Incorrect Argument Set error :-(

Nick Korna

@AGorgei

This should do the trick if you're after the %age of "Yes"' from the Contact & Support team:

=COUNTIFS([Opened For (populated with accurate EE name)]:[Opened For (populated with accurate EE name)], "Yes", Team:Team, "Contact & Support") / COUNTIFS(Team:Team, "Contact & Support")

If you're wanting the %age for Yes AND Contact & Support as a total of all lines:

Let me know if there are any problems/questions!

AGorgei

@Nick Korna The first one did it! You ROCK! THANK YOU!!!!!

Nick Korna

No problem, happy to have helped! 😊

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.