View Single Post
  #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