View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lene S Lene S is offline
external usenet poster
 
Posts: 3
Default Count with multiple criterias

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