Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet with 12 monthly budgets. Income and expenses are sorted
via due date and I use a running balance in the last column. Lets say rows 1-50 make up Jan. Somehow, I want to be able to automatically subtotal within the budget, certain expenses. To clarify, see below L1: Income (him) L2: Expense 1 L3: Expense 2 L3: Expense 3 Running Balance = 400 L4: Income (her) L5 Expense 4 L6: Expense 5 .. .. .. .. L12: Expense 11 Is there a way to automatically select expenses 4-11 to subtotal how much just that set of expenses are? Not sure if a macro will come into play here or not. Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
subtotal question? | Excel Worksheet Functions | |||
subtotal question | Excel Discussion (Misc queries) | |||
A new twist to the validation drop-down width question. | Excel Discussion (Misc queries) | |||
Subtotal Question | Excel Worksheet Functions | |||
Subtotal question | Excel Worksheet Functions |