Nested Ifs

Casey Hope

I need and if statement on a metric sheet that counts if 3 criteria are met.

If one column = this

If another column = that

If last column = "No"

This is what I have and I though it might work but I get the #UNPARSEABLE error.

=COUNTIFS({Range 1}, [Primary Column]3, FIND(AND({Range 3} = [Primary Column]9, {Range 2} "No")))

I also tried

=If{Range 1} = [Primary Column]3, Count({Range 1}), If(Range 2 = "No", Count({Range 1}), If({Range 3} = [Primary Column]9, Count({Range 1}, " ")))

I got the same error.

Find more posts tagged with

Formulas

functionality

Accepted answers

Paul Newcome

Try something like this...

=COUNTIFS({Range 1}, [Primary Column]3, {Range 2}, "No", {Range 3}, [Primary Column]9)

All comments

Paul Newcome

Try something like this...

=COUNTIFS({Range 1}, [Primary Column]3, {Range 2}, "No", {Range 3}, [Primary Column]9)

Casey Hope

Paul,

I tried that multiple times before and kept getting errors. Now that I tried it again it works.

Paul Newcome

Happy to help! 👍️

There are quite a few things that could cause errors. Syntax, an extra comma or parenthesis, a simple space where it shouldn't be...

HERE is a link that explains each of the errors and some basic troubleshooting tips for each of them, and of course you are more than welcome to reach out to the Community for help as well.

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.