Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal vs Pivot table - or best way | Excel Discussion (Misc queries) | |||
subtotal - pivot table - or better function | Excel Worksheet Functions | |||
Subtotal Bug in Excel 2003 | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |