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...
It looks like the first line counts old, unfinished cases and the following lines count current cases.
I think you just have to count cases with dates less than or equal to Today()+6
=COUNTIFS($H$9:$H83,"<="&TODAY()+6,$J$9:$J83,{"Not Started","In Progress"}))
I think you just have to count cases with dates less than or equal to Today()+6
=COUNTIFS($H$9:$H83,"<="&TODAY()+6,$J$9:$J83,{"Not Started","In Progress"}))
Thank you very much Richard_Wendt. Unfortunately, the formula produced a "spill" error. However, the formula provided by Oliver has worked, so all is good. I appreciate you helping!
