Countif statement

I am trying to count two separate columns based on the criteria below and am receiving the error "#Unparseable".

My formula is as follows: =COUNTIFS([Force Level_FRB]:[Force Level_FRB], ="10% / L2", and [PINS Case_FRB]1:[PINS Case_FRB]210))

The PINS Case_FRB column has two options: PINS and PINS_A, where applicable, otherwise the cell is blank if it is not one of the two options.

How do I get a count to know how many 10% / L2 cases are related to a PINS or PINS_A?


Your assistance is appreciated!

Jolene

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Try:

    =COUNTIFS([Force Level_FRB]:[Force Level_FRB], "10% / L2", [PINS Case_FRB]:[PINS Case_FRB], OR(@cell="PINS", @cell="PINS_A"))

    Am I understanding correctly?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!