On Thursday, November 6, 2014 3:24:39 PM UTC-8, GS wrote:
Howard,
My Invoicing: Simple Bookkeeping app does sums on its 'Summary'
sheet (P&L format) for each account of their respective sub
accounts using a worksheet formula that utilizes a hidden helper
column. This sheet gives both summary and detail views via
outlining so the sum amounts don't duplicate the detail amounts.
The primary function is SUMIF(), which pulls values from another
sheet rather than the existing sheet, but the formula can be made
to work either way. (My intent was to have 'Summary' (a read-only
sheet) auto-update when changes were made to either the 'Expenses'
sheet or the 'Income' sheet since they were the 'source' for the
consolidated values. (Consolidation is monthly, quarterly, and
year-to-date) I can avail a copy of the project workbook if you're
interested, but you'll need the NameManager addin to see the hidden
named formulas.

--
Garry


That's probably more horsepower than I need right now for what I'm
working on. With the small example I posted, there will also be a
need to enter formulas in a column that matches the sample, where the
formulas will return the % value of each cell in the sum group and
100% will be in the total sum row.

But that is a bit down the road until I get the code Claus offered
into the fray.

Standby, if you will. My inabilities have no boundaries.<g

Howard

Ah! My workbook also does % both ways:
Income accounts show %TotalIncome and %TotalExpense
Expense accounts show %TotalExpense and %TotalIncome

...for each account/subaccount.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion