Formula Help - multiple criteria & ranges

Hi community!

I need HELP. I have been hitting my head against a wall trying to write a formula to calculate across different ranges and criteria. See photo for example of data. My formulas are not working out.

What I am trying to calculate is: Countifs

1) All PEM except PAC Support Center

2) Do not include rows with "opted out" checked

3) Any status except "connected"

4) kick-off is yes

5) risk is low

Thank you to any/all who can offer suggestions!

Find more posts tagged with

Formulas

Accepted answers

Taylar LaBonte

@Samuel Mueller I don't know how to thank you!! It worked! I had no idea "<>" was even a thing. Problem solved - I should have posted this question sooner.

Thank you!!

All comments

Samuel Mueller

Something like this should work:

=COUNTIFS(PEM:PEM, <>"Support Center", [Opted Out]:[Opted Out], 1, Status:Status, <>"Connected", [Kick-off]:[Kick-off], "Yes", Risk:Risk, "Low")

countifs has a criteria range, and then the criteria. The range is the column that has a criteria you want to count, and then the criteria for that range is what you want to count or not.

Checkboxes are 0 or 1. does not equal is the <>.

If you don't use an entire column for a range - all the criteria ranges musts be the same size.

Does that help?

Taylar LaBonte

@Samuel Mueller I don't know how to thank you!! It worked! I had no idea "<>" was even a thing. Problem solved - I should have posted this question sooner.

Thank you!!

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.