I am working on a Spreadsheet with 3 sheets.
1st is 'By Rep' tab
2nd is 'By Region' tab
3rd is 'By Total' tab
I was given this spreadsheet to finish by a worker who is no longer here. I am confused as to how to finish the 3rd sheet - 'By Total'.
The first sheet has a bunch of data by Rep. There are several reps on this sheet. Data has been calculated for 5 key rows - All Cases, Basic Life, Optional Life, Short Term Disability and Long Term Disability. Within each of these key rows there are months - January through December. There are 4 key columns - All Business Segments, Key Accounts, Major Accounts and Special Accounts. Within each of these columns there are 3 more columns for 2004, 2005 and % of change.
The second sheet has just compiled the 'By Rep' data into 'By Region'. For example, there were several reps in the CN Region, so in the 'By Region' worksheet they are all under CN.
Now...I need to take all the Regions and total them up for All Cases, Basic Life, Optional Life, Short Term Disability and Long Term Disability. And for Key Accounts, Major Accounts and Special Accounts.
So...I will attach a sample of what I am working on and maybe someone can assist me.
This is taken from the 'By Region' tab. If someone call help me I can e-mail you the entire spreadsheet for you to take a look at.
Edited by firefytr: Nov 7, 2005, 1835 hrs. GMT; Reason: HTML Maker post mishap.
1st is 'By Rep' tab
2nd is 'By Region' tab
3rd is 'By Total' tab
I was given this spreadsheet to finish by a worker who is no longer here. I am confused as to how to finish the 3rd sheet - 'By Total'.
The first sheet has a bunch of data by Rep. There are several reps on this sheet. Data has been calculated for 5 key rows - All Cases, Basic Life, Optional Life, Short Term Disability and Long Term Disability. Within each of these key rows there are months - January through December. There are 4 key columns - All Business Segments, Key Accounts, Major Accounts and Special Accounts. Within each of these columns there are 3 more columns for 2004, 2005 and % of change.
The second sheet has just compiled the 'By Rep' data into 'By Region'. For example, there were several reps in the CN Region, so in the 'By Region' worksheet they are all under CN.
Now...I need to take all the Regions and total them up for All Cases, Basic Life, Optional Life, Short Term Disability and Long Term Disability. And for Key Accounts, Major Accounts and Special Accounts.
So...I will attach a sample of what I am working on and maybe someone can assist me.
This is taken from the 'By Region' tab. If someone call help me I can e-mail you the entire spreadsheet for you to take a look at.
Edited by firefytr: Nov 7, 2005, 1835 hrs. GMT; Reason: HTML Maker post mishap.
