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:
[TABLE="width: 268"]
<tbody>[TR]
[TD]Criteria A[/TD]
[TD]Criteria B[/TD]
[TD]Criteria C[/TD]
[TD]Count column[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]netherlands[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]UK[/TD]
[TD]Feb[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Germany[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]netherlands[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]netherlands[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]UK[/TD]
[TD]Feb[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Germany[/TD]
[TD]Jan[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]UK[/TD]
[TD]Feb[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Germany[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]netherlands[/TD]
[TD]Feb[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]UK[/TD]
[TD]Jan[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Germany[/TD]
[TD]Feb[/TD]
[TD="align: right"]0
[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"></colgroup>[/TABLE]
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:
[TABLE="width: 268"]
<tbody>[TR]
[TD]Criteria A[/TD]
[TD]Criteria B[/TD]
[TD]Criteria C[/TD]
[TD]Count column[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]netherlands[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]UK[/TD]
[TD]Feb[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Germany[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]netherlands[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]netherlands[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]UK[/TD]
[TD]Feb[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Germany[/TD]
[TD]Jan[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]UK[/TD]
[TD]Feb[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Germany[/TD]
[TD]Jan[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]netherlands[/TD]
[TD]Feb[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]UK[/TD]
[TD]Jan[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Germany[/TD]
[TD]Feb[/TD]
[TD="align: right"]0
[/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"></colgroup>[/TABLE]
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