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))
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))
