Hi,

The answer is probably - but how do you destinguish the Expenses 4-11 are
they actually call Expenses 4, Expenses 5...? Are the expenses you want to
sum based on something or just random? Do you always want to sum the
expenses in a range, that is from 4 to 11, not 4, 7, 9, and 11 (non adjacent
ones)?

--
Cheers,
Shane Devenshire


"WLMPilot" wrote:

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