Forum Discussion
Formula for COUNTIFS combined with OR (I think)
Hello, Please can someone help me with a formula for the following: Column E is labelled "Priority" with drop down options of "High", "Medium" or "Low" from a lookup table. Column I is label...
Assuming the columns of you table are named (or you could use structured references)
= COUNTIFS(Priority, "High", Status, "<>Complete")Sorry, the forum was showing 0 responses. Still, good to know we are in agreement!