Countifs formula

Hobo

Hi Team reaching out for some help again, i need a countifs formula to count all the high priority actions (Priority column) that are currently either not started or ongoing (Status column)

Thanks in advance

AravindGP

Hi @Hobo ,

You can use this formula. The formula will count rows where priority is high and status is not completed.

=COUNTIFS(Priority:Priority, "High", Status:Status, <> "Completed")

AravindGP

Hi @Hobo ,

You can use this formula. The formula will count rows where priority is high and status is not completed.

=COUNTIFS(Priority:Priority, "High", Status:Status, <> "Completed")

Hobo

Thanks worked perfectly!!