Calculating Average Salaries with Three Other Variables - Pivot Tables?

R

RobFJ

I've four columns of data over three hundred rows :

Gender - M or F
Grade - 1 to 15
Company - Five text names
Salary - Integer figure

I want to be able to create tables where, by company, I can calculate the
average salaries of men and women by grade.

I know it probably is a pivot table but can't get the steps right to get to
where I want.

Can SKS help with the rough pivot table steps or a generic formula that I
could customise.

(The four columns of data are each range-named.)

Thanks
 
B

Bernard Liengme

Send me a file with sample data - change company names if confidential
Tell me what version of Excel you use (Excel2003- or Excel2007+)
I will make a movie of how to generate pivot table
And show a SUMPRODUCT (or AVERAGEIFS for Excel2007) solution
Get my email from my website
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top