Creating an age or service spread chart

[Dave Bradshaw]

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.

 

[Don Guillett]

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)