software

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.
=SUMPRODUCT(--($A$2:$A$200=quot;1-4quot;),--($B$2:$B$200gt;=0.5),--($B$2:$B$200lt;=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)

quot;Chris Gquot; lt;Chris gt; wrote in message
...
gt; I need to count the number of performance ratings within a couple of
groups.
gt; E.g., count the number of employees in bands 1-4 with performance ratings
gt; between 0.5 and 1.69 then with rating between 1.7 and 1.99, etc. Then I
need
gt; to do the same thing for the other employee groups.
gt;
gt; There are approximately 20 bands that make up 5 groups of emps and 30
gt; numeric ratings that make up 5 groups.
gt;
gt;