Forum Discussion
Countifs question.
And what COUNTIFS returns:
With first condition we iterate records with Tyskland. First one has 1, with second condition we iterate all records in second position counting where the score is less than 1. It gives 1,1,0,1,0,0. When repeat the same with second Tyskland. Since it has zero, comparing with scores in second column we have 0,0,0,0,0,0. No more Tyskland, sum one with another and have result which we have.
Thank you Martin_Angosto
But I am still confused why L4 shows 1 in the previous picture. And i L13:L16 here:
And what COUNTIFS returns:
With first condition we iterate records with Tyskland. First one has 1, with second condition we iterate all records in second position counting where the score is less than 1. It gives 1,1,0,1,0,0. When repeat the same with second Tyskland. Since it has zero, comparing with scores in second column we have 0,0,0,0,0,0. No more Tyskland, sum one with another and have result which we have.