Forum Discussion

MathijsSerlie's avatar
MathijsSerlie
Copper Contributor
Jan 26, 2024
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...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jan 26, 2024

    MathijsSerlie 

    I suspect you need to use the semi-colon to separate the items of the 'search' array.

    =COUNT(SEARCH({"WD";"08"},E22:R22))

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 26, 2024

MathijsSerlie 

I suspect you need to use the semi-colon to separate the items of the 'search' array.

=COUNT(SEARCH({"WD";"08"},E22:R22))