Using COUNTIFS with AND

Hi! I'm trying to count the number of items which have one status as "Operational" and another status with any option EXCEPT "Operational". This is the formula I have but it is getting an error as UNPARSEABLE. Note that I'm using a cross-sheet reference. Thanks!


Tags:

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @deb_63_hydracor

    The syntax of your formula looks correct. Would you be able to show screen captures of the two {references} in the pop-up window? (But please block out sensitive data).

    Is it possible that either of these ranges have a formula in them which may be returning an error?

    What happens if you try each criteria on its own, like so:

    =COUNTIFS({SSL Exp Rounding Status}, "Operational")

    =COUNTIFS({SSL EHR Integration Status}, <> "Operational")

    Cheers!

    Genevieve

  • deb_63_hydracor
    deb_63_hydracor ✭✭✭✭✭✭

    Hi Genevieve! Thanks for your quick response! I got the formula to work! It's not giving me the correct answer, but at least no errors.


    Thanks and have a great weekend!

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @deb_63_hydracor

    I'm glad to hear you're no longer seeing an error! However the formula should give you the correct Count... if you're still having trouble please let me know and I'd be happy to take a look at some screen captures to see what may be happening.

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!