Countifs... something off

Kait Bankey

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"

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