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...
=SUM(COUNTIFS($E$7:$E$13,"high",$I$7:$I$13,{"In progress","Not started"}))
=SUMPRODUCT(($E$7:$E$13="high")*(($I$7:$I$13="In progress")+($I$7:$I$13="Not started")))
Does any of these formulas return the intended result?
OliverScheurichThank you so much! That worked a treat!