Display when subtotaling.
 

I am subtotaling by account numbers and would like to display both the
account number and account titles.
Spreadsheet looks like:
AcctT, Acct#, SubAcct#
Cash, 001, 01
001, 02
001, 04
When I subtotal by acct number I get "Total 001". The subtotal function
doesn't give you an option to display additional data. I would like to
display the Account Title also. Any simple suggestions?

Display when subtotaling.
 

One way is to concatenate the two fields in a new column, then create your
subtotals by that column. For example, assuming your example data begins in
A1:

- insert a new column A
- in A1 give it the heading Account
- in A2, enter =C2&" "&B2
- copy A2 down through all rows of data
- create your subtotals at each change in Account

Hope this helps,

Hutch

"Bookmdano" wrote:

I am subtotaling by account numbers and would like to display both the
account number and account titles.
Spreadsheet looks like:
AcctT, Acct#, SubAcct#
Cash, 001, 01
001, 02
001, 04
When I subtotal by acct number I get "Total 001". The subtotal function
doesn't give you an option to display additional data. I would like to
display the Account Title also. Any simple suggestions?

Display when subtotaling.
 

You can use a pivot table instead of subtotals

http://www.contextures.com/xlfaqPivot.html

--


Regards,


Peo Sjoblom

"Bookmdano" wrote in message
...
I am subtotaling by account numbers and would like to display both the
account number and account titles.
Spreadsheet looks like:
AcctT, Acct#, SubAcct#
Cash, 001, 01
001, 02
001, 04
When I subtotal by acct number I get "Total 001". The subtotal function
doesn't give you an option to display additional data. I would like to
display the Account Title also. Any simple suggestions?