Count if formula help

Marivi

Hi, looking to get total of items flagged "1-CRITICAL" under "Priority" column, that are not marked "COMPLETED" in "Status" column. No matter what I do - I get an error.

Anjanesh Vaidya

Hi Marivi,

Can you provide some Screenshot for context?

Thank You!

Anjanesh Vaidya

Purnima Gore_PGPS

Hi @Marivi

The answer I get in the sheet summary is 2.

Let me know if this works

Kind regards

Purnima