#1   Report Post  
basic
 
Posts: n/a
Default Subtotal

Below I used the Subtotal function to come up with the sum of hours everytime
the Ecode changed.

I would like the Year to also show up after I subtotal. As it is now I have
to add each year in individually even though it has a direct correlation with
the ECode.

ECode Hours Year
B Total 48
D Total 48
E Total 15
M Total 584
O Total 31.75
P Total 51
S Total 32
B Total 112
D Total 324.25
E Total 187
F Total 618.5
J Total 24
M Total 5165.25
O Total 16
P Total 405.75
S Total 760.25
Z Total 487.25

I would like to have it look like this:

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Subtotal vs Pivot table - or best way klafert Excel Discussion (Misc queries) 2 June 16th 05 06:29 PM
subtotal - pivot table - or better function klafert Excel Worksheet Functions 0 June 16th 05 06:12 AM
Subtotal Bug in Excel 2003 GON Excel Discussion (Misc queries) 2 May 10th 05 08:42 PM
pivot table - hide details but show subtotal for calculated field tenneym Excel Discussion (Misc queries) 1 February 9th 05 03:07 AM
Subtotal of Subtotal displays Grand Total in wrong row Thomas Born Excel Worksheet Functions 5 January 6th 05 01:46 PM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"