+ Reply to Thread
Results 1 to 8 of 8

Pivot table subtotals by Customer code

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Pivot table subtotals by Customer code

    One way is to put the following in K2:

    =SUMIF($A$2:$A$36,A2,$J$2:$J$36) and copy down
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  2. #2
    Forum Contributor
    Join Date
    01-18-2010
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    128

    Re: Pivot table subtotals by Customer code

    Quote Originally Posted by Søren Larsen View Post
    One way is to put the following in K2:

    =SUMIF($A$2:$A$36,A2,$J$2:$J$36) and copy down
    Hi Søren,
    This didn't seem to work. It just shows the number on the first row in each Customer Code group, so for CM5, it shows 69.55
    Any modification of this code?
    Thank you,
    Eva

+ 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