Posted on:

12 Nov 2022


Countifs with 2 different criterias and the same range

I tried to write this function below, to find the number of teams from Germany and Italy, but it returned zero

I was only able to have the expected result by writing the function below

Is it possible to have the expected result using COUNTIFS ?

Thank you.

0 answers ( 0 marked as helpful)

Submit an answer