Display when subtotaling.

B

Bookmdano

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?
 
T

Tom Hutchins

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
 
Top