Forum Discussion
Countifs Formula
Hi, I'm stuck and need help. I'm looking for a countifs formula that searches in a range for multiple criteria. I tried it with some exampes I found online but without a positive result. The fo...
I suspect you need to use the semi-colon to separate the items of the 'search' array.
=COUNT(SEARCH({"WD";"08"},E22:R22))
Alternatively, maybe this formula could be useful for you.
=COUNT(FILTER(E22:R22, (ISNUMBER(SEARCH("WD", E22:R22))+ISNUMBER(SEARCH("08", E22:R22)))>0))
This formula should work in both Office 365 Excel and Excel Online. If you have merged cells within the range, please be cautious, as formulas might behave differently in merged cells. Ensure that the merged cells do not interfere with the logic of your formula.
