Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subtotal and Total Columns
I have a spreadsheet that lists expenditures of different departments.
Each department is separated from the next by two blank rows and is of various lengths from day to day. How can I subtotal the expenditure column of each dept so that the subtotal appears in the first blank row below that dept and then totals the whole column ( making sure the subtotals don't get added again)? Thanks for any help. Gib --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove ##### from subtotal and total rows | Excel Discussion (Misc queries) | |||
Subtotal results without word "Total" | Excel Worksheet Functions | |||
can I put total value from subtotal into next column | Excel Discussion (Misc queries) | |||
total subtotal cells | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |