Hello,
Currently I am having a problem with a count issue.
From a table I need to count a number of items based on several conditions, so I used the countifs formula.
I have for example 2 criteria already set in the countifs formula.
see below for example:
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
Now they need to count all A and B's, for January.
But my issue is, I want only unique countries to be counted. Here Netherlands is counted for 3, but this needs to be 1.
Do I use the correct formula (countifs)? or how does it need to be adjusted?
thanks,
Suk In
Currently I am having a problem with a count issue.
From a table I need to count a number of items based on several conditions, so I used the countifs formula.
I have for example 2 criteria already set in the countifs formula.
see below for example:
Criteria A | Criteria B | Criteria C | Count column |
A | netherlands | Jan | 1 |
A | UK | Feb | 0 |
A | Germany | Jan | 1 |
A | netherlands | Jan | 1 |
B | netherlands | Jan | 1 |
B | UK | Feb | 1 |
B | Germany | Jan | 0 |
B | UK | Feb | 1 |
B | Germany | Jan | 1 |
B | netherlands | Feb | 1 |
B | UK | Jan | 0 |
B | Germany | Feb | 0 |
<tbody>
</tbody><colgroup><col><col><col span="2"></colgroup>
Now they need to count all A and B's, for January.
But my issue is, I want only unique countries to be counted. Here Netherlands is counted for 3, but this needs to be 1.
Do I use the correct formula (countifs)? or how does it need to be adjusted?
thanks,
Suk In