Hi everyone,
Apologies if this appears to be a newbie question:
I am have an Excel workbook where I keep the salaries of staff. Each sheet represents a dept. Inside every sheet, I keep the Rank of Staff, Names, Title, Salary, Bonuses, etc
The data is kept by row and the fields are in the columns.
I would like to do a summary of each Rank and position from the data contained in the sheets
For eg, Rank 1 - General Manager, Senior Manager
Rank 2 - Managers
Rank 3 - Assistant Managers, Buyers, etc
the list goes on.
In this summary, I would like to reflect the quantum of bonuses by each rank and order by their Position.
For eg, if I were to select Rank 3, how should I write my formula to sum up the bonuses only for Rank 3 and how can I then retrieve the Position for further ordering/sorting.
I wonder what is the best way to do this without too much intermediate steps.
Thanks in advance!
Serene
Apologies if this appears to be a newbie question:
I am have an Excel workbook where I keep the salaries of staff. Each sheet represents a dept. Inside every sheet, I keep the Rank of Staff, Names, Title, Salary, Bonuses, etc
The data is kept by row and the fields are in the columns.
I would like to do a summary of each Rank and position from the data contained in the sheets
For eg, Rank 1 - General Manager, Senior Manager
Rank 2 - Managers
Rank 3 - Assistant Managers, Buyers, etc
the list goes on.
In this summary, I would like to reflect the quantum of bonuses by each rank and order by their Position.
For eg, if I were to select Rank 3, how should I write my formula to sum up the bonuses only for Rank 3 and how can I then retrieve the Position for further ordering/sorting.
I wonder what is the best way to do this without too much intermediate steps.
Thanks in advance!
Serene
