Hi all,
I have a workbook with three tabs:
Report
Data
Groupings
Report has the following info:
Group Amount
A <need formulas here>
B
C
Data has a list of accounts and balances. Groupings has a list of all
possible accounts and what group they below to (A,B,C,etc.)
My question is: on the report tab, can I use a domain function to sum
all amounts from the Data tab into their proper groupings? The groups
will have to be looked up on the Groupings tab by account. This would
be an elegant solution if possible. Otherwise, I'm going to have to
duplicate data (i.e. - do another report with the accounts, groupings,
and balance and use plain vanilla sumifs) or do something in VBA to
generate the Report tab.
Thanks in advance,
Johnny
Bookmarks