Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: HELP!!!! I need to sum and get averages of data with varying

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The data may look like this:

    SKU Region #s sold

    100 1 1000
    100 2 5000
    100 3 4000
    101 1 3000
    102 2 500
    102 5 500
    103 1 1000
    103 2 1000
    103 4 3000

    I need it to calculate the pct of total for each SKU.....first I can subtotal by SKU to get the totals, but then I'd have to manually add a column of formulas to calculate %

    Final data would look like this

    SKU Region #s sold Pct of SKU

    100 1 1000 10%
    100 2 5000 50%
    100 3 4000 40%
    101 1 3000 100%
    102 2 500 50%
    102 5 500 50%
    103 1 1000 20%
    103 2 1000 20%
    103 4 3000 60%


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    With your data in A1:C10 enter the formula, =C2/SUMIF($A$2:$A$10,A2,$C$2:$C$10), into D2 and copy down to D10. Format D2:D10 as 0%

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    THANKS A LOT MARK, WORKED LIKE A CHARM!!!!!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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