Forum Discussion
Solved
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))
=COUNT(SEARCH({"WD","08"},E22:R22))
This formula returns the intended result in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
Thanks for your quick reply.
Unfortunately it doesn't work. I use Office 365 and/or Microsoft Excel online.
Could it be because I merged the cells?
I suspect you need to use the semi-colon to separate the items of the 'search' array.
=COUNT(SEARCH({"WD";"08"},E22:R22))