Posted on:

12 Nov 2022

0

Countifs with 2 different criterias and the same range

Hello,
I tried to write this function below, to find the number of teams from Germany and Italy, but it returned zero
=COUNTIFS(C4:C12;"Germany";C4:C12;"Italy")

I was only able to have the expected result by writing the function below
=SUM(COUNTIF(C4:C12;"Germany")+COUNTIF(C4:C12;"Italy"))

Is it possible to have the expected result using COUNTIFS ?

Thank you.

0 answers ( 0 marked as helpful)

Submit an answer