how do I count with multiple arguments

[Guest]

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.

 

[Bob Phillips]

=SUMPRODUCT(--($A$2:$A$200="1-4"),--($B$2:$B$200>=0.5),--($B$2:$B$200<=1.69)
)

etc.

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)