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"

Tags:

Answers

  • Ramzi K
    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

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: [email protected]

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • Kait Bankey
    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
    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

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: [email protected]

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • Kait Bankey
    Kait Bankey ✭✭✭

    Still coming up unparseable.... @Ramzi Khuri

  • Ramzi K
    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

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: [email protected]

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

  • Kait Bankey
    Kait Bankey ✭✭✭

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

  • Ramzi K
    Ramzi K ✭✭✭✭✭

    @kbankey77181

    Most Excellent! Glad to help.

    Cheers,

    Ramzi

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: [email protected]

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!