I have an XL2003 spreadsheet containing employee names, departments and dates
of birth. I would like to set up charts showing (a) how many people are in
each department and (b) how many people are of each age.
--
Dave B

You could set up a separate table to get the info. List the departments and
use an indirect sumproduct formula such as

=SUMPRODUCT((ChecksB=B10)*1)
or
=SUMPRODUCT((ChecksB=B10)*ChecksD)


--
Don Guillett
SalesAid Software

"Dave Bradshaw" wrote in message
...
I have an XL2003 spreadsheet containing employee names, departments and
dates
of birth. I would like to set up charts showing (a) how many people are
in
each department and (b) how many people are of each age.
--
Dave B