Countif logic not working
I need a formula that should count the based on Priority High, Medium, Low .
So if the priority is High and Status is Completed it should count the number on closed column
if the priority is High and status is In progress,Hold its should count the number on open column
like wise we have to do for Low and medium.
Below I have prepared the Summary sheet were the count should refect.
and this is the input sheet
Please help in getting the formula.
Help Article Resources
Check out the Formula Handbook template!