Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2003
    Location
    Houston, Texas, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    subtotals (Excel 2000)

    Is it possible without programming to have the subtotals show in the next column to the right. I can manually handle it after the subtotals but I am hoping for a quick, easy and elegant way to do this - to show my users.

    thanks for all and any help

  2. #2
    5 Star Lounger
    Join Date
    Oct 2002
    Location
    Wellington, Wellington, New Zealand
    Posts
    621
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subtotals (Excel 2000)

    You could make a new column with a formula like

    =IF(ISERROR(SEARCH("*Total*",A2)),"",B2)

    where Column B should be replaced with whatever column holds the value of the total

Posting Permissions

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