LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif with multiple criterias Doug Excel Worksheet Functions 2 August 18th 07 08:22 AM
DCOUNT WITH MULTIPLE CRITERIAS cltjohn Excel Worksheet Functions 2 May 17th 06 10:30 AM
Formula format for Count or Countif funtion with two criterias Debi Excel Worksheet Functions 2 September 26th 05 08:23 PM
countif help for multiple criterias tdro Excel Worksheet Functions 2 June 14th 05 05:06 PM
Multiple Data Validation Criterias MCorrea Excel Worksheet Functions 4 January 20th 05 07:17 PM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"