Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Word Total and Grand Total
I have a spreadsheet where I have used the subtotal
function to get subtotals and grandtotals based on a particular code. However, it would be nice if I could change them to something that makes more sense. The subtotals are in Column E and the subtotals have codes like 32000 Total, 33000 Total. In other words each subtotal has three zeroes and the word Total in common. Col D has names and I would like the subtotal to say offset (-1,-1).Value & "Total". That would give me Jim Total or the Fred Total etc. Where the word Grand Total comes in at the bottom of the range, I would like to change it to Points Total. I would appreciate any help. Thank you. --Indu |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
Should grand total equal average of sub total | Excel Discussion (Misc queries) | |||
Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions |