Hello,
I have two columns
Priority , Status
For priority i have P1,P2,P3
Status = open,closed

I want to find basically how many P1 are open based on some formula

I used countif function to find how many P1,P2,P3 but i want to know how many of those P1 are open and how many P1 are closed.

I want to calculate these metrics on different sheet.

Any help please?