Complex COUNTIFS and IF Function

Hello,

I need help putting together a function that can count certain cells in my grid. The inputs of the function are the following:

If Beta is "Yes", it should be counted twice
If Beta is "No", it should be counted once
But if the Primary Region Column is not checked, the row should not be counted at all.

Beta is a column with only yes or no selectable answers, Primary Region is another column that is a checkbox.

I need the total sum of how this is added up after these inputs are accounted for, is this doable?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

=COUNTIFS([Regional Beta Platform Created]:[Regional Beta Platform Created], "Yes", [Primary Region]:[Primary Region], 1) * 2 + COUNTIFS([Regional Beta Platform Created]:[Regional Beta Platform Created], "No", [Primary Region]:[Primary Region], 1)

What about the [Primary Region] column name?

Can you copy/paste the formula directly from the sheet? There are a lot of different reasons why you could be getting that area. Another option would be to provide a screenshot of the formula in the sheet similar to below:

All comments

Paul Newcome

Try something like this...

=COUNTIFS(Beta:Beta, "Yes", [Primary Region]:[Primary Region], 1) * 2 + COUNTIFS(Beta:Beta, "No", [Primary Region]:[Primary Region], 1)

Mashall Greene

Hey Paul,

Thank you, I understand the logic of this function and it seems like it should work, but I am getting an "#UNPARSEABLE" error, is there something we could be missing?

This function is living in a Sheet Summary field, is that an issue?

Paul Newcome

Can you copy/paste the formula directly from the sheet?

Depending on your region, you may also need to swap out the commas for semi-colons.

=COUNTIFS(Beta:Beta; "Yes"; [Primary Region]:[Primary Region]; 1) * 2 + COUNTIFS(Beta:Beta; "No"; [Primary Region]:[Primary Region]; 1)

Also double check to make sure the column names are correct.

Mashall Greene

No luck with commas or semi-colons, on my sheet Beta is actually called "Regional Beta Platform Created", but I've been updating your formulas accordingly.

I am also in the US, is there a way we can get on the phone?

Paul Newcome

What about the [Primary Region] column name?

Mashall Greene

That worked! Thank you!!!

Paul Newcome

Happy to help! 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.