Countifs... something off

Hi there! I am trying to do a COUNTIFS formula for a sheet where I am nesting three formulas into one for results.

There are three different columns(ranges) I am using - doing the formula in sheet summary as well. Each of the three formulas works in themselves, but when I nest them together I receive Unparseable...

Any thoughts? Below are the three separate formulas:

COUNTIFS({RCO - Restaurant Tracker Range 3}, [--]@row

COUNTIFS({RCO - Restaurant Tracker Range 1}, 1

COUNTIFS({RCO - Restaurant Tracker Range 2}, "2004"

Find more posts tagged with

Formulas

Accepted answers

All comments

Ramzi K

@kbankey77181

Can you please share the nested formula. You likely have a syntax error or a missing/extra character in there.

Please tag me with @ so I see you response.

Cheers,

Ramzi

Kait Bankey

=COUNTIFS({RCO - Restaurant Tracker Range 3}, [--]@row, [{RCO - Restaurant Tracker Range 1}, 1], [{RCO - Restaurant Tracker Range 2}, "2004"]) @Ramzi Khuri

I've tried a few different ones... but here is one.

Ramzi K

@kbankey77181

This may be your issue. It appears you may have an extra characters here:

Does this work?

=COUNTIFS({RCO - Restaurant Tracker Range 3}, [--]@row, {RCO - Restaurant Tracker Range 1}, [{RCO - Restaurant Tracker Range 2}, "2004"])

Cheers,

Ramzi

Kait Bankey

Still coming up unparseable.... @Ramzi Khuri

Ramzi K

@kbankey77181

When you say "nesting" are I assume you mean combining. That is you want the Count if ALL conditions are true?

If that's the case, try this:

=COUNTIFS({RCO - Restaurant Tracker Range 3}, [--]@row, {RCO - Restaurant Tracker Range 1}, 1, {RCO - Restaurant Tracker Range 2}, "2004")

Note: My apologies, as I had a syntax error in my own formula that I sent you.

Cheers,

Ramzi

Kait Bankey

THAT WORKED! Thank you SO much!! @Ramzi K

Ramzi K

@kbankey77181

Most Excellent! Glad to help.

Cheers,

Ramzi

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.