COUNTIFS on multiple columns looking for multiple conditions.

jambla
jambla
edited 04/02/20 in Formulas and Functions

Hi,


Im trying to count how many rows fit a specific criteria.

Here is my example table:



In this example I want to count how many rows are assigned to "In House" with a Status of "In" and Difficulty of "A".


This is my formula:

=COUNTIFS([Assigned To]:[Assigned To], "In House", [Status]:[Status], “In”,[Difficulty]:[Difficulty], “A” )


When I do that I get #UNPARSEABLE


Any help would be much appreciated!

Best Answer

Answers

  • Worked perfectly! Thanks Andrée!

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Excellent!

    Happy to help!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.