Creating an age or service spread chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top