Maybe I didn't made it clear, sorry.
In real life I do not know the order number, why I cannot use your formula.
And actually I do not care whether it is order A, B or something else.
I just want to count how many different orders numbers based upon the
criterias as to week number and machine number.
--
Regards
Lene S


"Carim" skrev:

Hi,

Mike is right ...
But you seem to have three and not two criteria :

=SUMPRODUCT((A2:A6=40)*(B2:B6=1)*(C2:C6="A")

HTH
Carim