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