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")- Thanks Peter! I think this will count completed items however I'm looking to count not started and in progress items. But I can use a combo of your suggestions and Oliver's suggestions for a clean formula. There are other tables crossing into the same column, so I think a cell-specifc formula may be best rather than a column-specific formula. However, this is great to know for future spreadsheets!
Just to clarify the syntax, the status
"<>complete"means the formula returns a count for items that are not complete. That is because of the "<>" not equal to.
Sorry, the forum was showing 0 responses. Still, good to know we are in agreement!
