Count with multiple criterias
Try this:
=SUM(N(FREQUENCY(IF((Week=40)*(Machine=1),MATCH(Or der,Order,0)),MATCH(Order,Order,0))0))
ctrl+shift+enter, not just enter
"Lene S" wrote:
Hi
I need Excel to count the unique appearances based upon two criterias.
The columns needed is:
Week Machine Order
40 1 A
40 1 B
40 1 A
40 2 C
41 1 D
41 1 A
How do I count the unique numbers of orders in week 40 and for machine 1? In
this case 2.
Thanks in advance
Lene S
|