Help with COUNTIFS Formula

Help with COUNTIFS Formula

I'd like to count if the priority = high and the status = final version

In other words, what is the total number of rows that equal both high priority and final version?

 

 

Capture_1.JPG

Comments

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

    Hi,

    Try something like this.

    =COUNTIFS(Priority:Priority; "high"; Status:Status; "final version")

    The same version but with the below changes for your and others convenience.

    =COUNTIFS(Priority:Priority, "high", Status:Status, "final version")

    Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

    Did it work?

    I hope that helps!

    Have a fantastic week!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    work-bold

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.