MarvinP,

Thanks for your response.

I do have the salary data.

What I would like is Excel to calculate the spread between the average male and female salaries by department.

For example, in my data base:

Column "A" has the department number.
Column "B" has the salary
Column "C" has male or female

Each department may have 10 to 200 rows of data. So I want excel to calculate the spread (# of standard deviations) between male and female average salaries for each department automatically.

Can that be done.

Thanks.