Maybe this

=SUMPRODUCT((A2:A7=40)*(B2:B7=1)*(C2:C7="A"))

Mike


"Lene S" wrote:

Hi Mike

The formula returns 3 and this is not the result I am looking for.
Machine 1 have spent time on 3 orders in week 40 but order A appears twice.
I need the formula to count the number of different orders = 2 in this case.
--
Regards
Lene S


"Mike H" skrev:

Perhaps

=SUMPRODUCT((A2:A6=40)*(B2:B6=1))

Mike

"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