extend information into cells after doing subtotal Excel

[kblostyankee]

I am trying to print a report with subtotlas, however, I want all information
from previous cells to show up in the subtotal column, can anyone help?
Thanks,
Kathleen

 

[JonR]

Try using the concatenate function. You may have to intersperse a " "
between your values.

Ex.

If you have the values 1,2,3,4 in cells A1:A4

=CONCATENATE(A1," ",A2," ",A3," ",A4," ",SUM(A1:14))

will give you

1 2 3 4 10