Countif/And/Or

Options

Trying to Count, by State, if multiple criteria is met. I think I am close....but don't have something in the right place! Any help is appreciated!

=COUNTIFS(AND({State}, "FL", ({Activity}, OR(@cell = "ASA", @cell = "ASA (Multiple Systems)"))))

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    edited 02/13/23
    Options

    Hi @Smarty ,

    You can do this as a sum of the 2 conditions:

    =COUNTIFS({State},"FL", {Activity},"ASA")+COUNTIFS({State},"FL", {Activity},"ASA (Multiple Systems")

    Or combine them into a single statement:

    =COUNTIFS({State}, "FL", {Activity}, OR(@cell = "ASA", @cell = "ASA (Multiple Systems)"))

    Hope this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!