LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
seve
 
Posts: n/a
Default Counting for two criteria - brain drain

Any help would be greatly appreciated.

I need to count the number of dates in column C for each rep (column A)
for each Equipment type (column C).

A B C
Rep Eqp Date
1 a 31-Jan
2 b 31-Jan
1 a 1-Feb
2 a

result should be Rep one has 2 Rep two has -0- for equipment type a.
Thanks,

Steve

 
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
Counting Cells with multiple criteria.One criteria supporting wild Azhar Arain Excel Worksheet Functions 1 January 12th 05 08:33 AM
2 Criteria Counting PGiessler Excel Worksheet Functions 2 January 10th 05 07:27 PM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 2nd 04 11:04 PM
counting with a criteria in multiple transactions shafali Excel Worksheet Functions 1 November 29th 04 01:15 AM
Counting "rows", i.e. simultaneous criteria for multiple cells gkline Excel Worksheet Functions 2 November 19th 04 07:30 AM


All times are GMT +1. The time now is 05:09 AM.

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"