+ Reply to Thread
Results 1 to 2 of 2

Subtotals from multiple columns?

  1. #1
    grjk
    Guest

    Subtotals from multiple columns?

    I subtotaled (sum) on 3 columns based on changes in a 4th column. There is a
    5th column (repeating text info in all cells in the subtotaled groups) that I
    want to display in the subtotaled (level 2) row. How do I get it to show?

  2. #2
    Guest

    Re: Subtotals from multiple columns?

    Hi
    Go to Data/Subtotals again and select the subtotal requirement. Make sure
    you uncheck 'Replace current subtotals' before you click OK.

    Andy.

    "grjk" <grjk@discussions.microsoft.com> wrote in message
    news:00B05D9E-E674-4628-9BD1-59DFAEF4D1EE@microsoft.com...
    >I subtotaled (sum) on 3 columns based on changes in a 4th column. There is
    >a
    > 5th column (repeating text info in all cells in the subtotaled groups)
    > that I
    > want to display in the subtotaled (level 2) row. How do I get it to show?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1