View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris G
 
Posts: n/a
Default how do I count with multiple arguments

I need to count the number of performance ratings within a couple of groups.
E.g., count the number of employees in bands 1-4 with performance ratings
between 0.5 and 1.69 then with rating between 1.7 and 1.99, etc. Then I need
to do the same thing for the other employee groups.

There are approximately 20 bands that make up 5 groups of emps and 30
numeric ratings that make up 5 groups.