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)