need to add extra fields to subtotals

  • Thread starter Thread starter aeg42
  • Start date Start date
A

aeg42

When I run subtotals on a set of data, it's obviously not that flexible
in what it will display for the subtotals themselves. For instance, I
have a three column worksheet where the first column has a product #,
the second column has a description and the third column has a
quantity. When I run the subtotals, I do a sum on the quantity at each
change in product #. Pretty standard, right?

So the subtotals are there now, and on the left side of the screen, you
have the collapsible tree for the subtotal function, so I can collapse
the spreadsheet to only display the subtotals. The problem with this
is that it only shows the product # and the subtotal for the quantity.
The description basically disappears. Is there a way to get the
description to appear on the same line as the subtotals?

MUCH thanks in advance.

Andrew
 
aeg42 > said:
When I run subtotals on a set of data, it's obviously not that flexible
in what it will display for the subtotals themselves. For instance, I
have a three column worksheet where the first column has a product #,
the second column has a description and the third column has a
quantity. When I run the subtotals, I do a sum on the quantity at each
change in product #. Pretty standard, right?

So the subtotals are there now, and on the left side of the screen, you
have the collapsible tree for the subtotal function, so I can collapse
the spreadsheet to only display the subtotals. The problem with this
is that it only shows the product # and the subtotal for the quantity.
The description basically disappears. Is there a way to get the
description to appear on the same line as the subtotals?

MUCH thanks in advance.

Andrew
Click to expand...

As far as I know, you cannot get this to happen automatically. However, you
can easily add them manually. For example, suppose row 6 is your first
subtotal row and column B is your description column. B6 will be blank. You
could put the formula =B5 in here to replicate the description. You can then
copy this cell into all the other subtotal rows, like this:
Copy cell B6.
Select cells in column B down to just before the grand total row. Then use
Edit > Go To > Special > Blanks
This will select all the column B cells in subtotal rows, so Paste will now
put the formula into them all.
 
Back
Top