Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2002
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sum Function by Groups (Excell 2000)

    Hope someone can help me out with this one... <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

    I have 80,000 records I need to look over for errors and I am trying to find a quicker and easier way to do this. I have attached a sample spreadsheet and a brief description of the problem. Please let me know what the best way of doing this would be.

    Thank you.
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Sum Function by Groups (Excell 2000)

    I would suggest a Pivot Table and attach your file with a sample of what I think you want.

    It also includes a screen capture of the PT wizard layout to show how it was achieved.

    Andrew C
    Attached Files Attached Files

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Sum Function by Groups (Excell 2000)

    In your sample data, should your example calculation in merged cell F3:F4 return 75% instead of 100%? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    I see that Andrew has again beaten me to the punch, and with a better answer, but -so far- I had

    =SUM(($C$2:$C$8=C2)*($D$2:$D$8=D2)*$E$2:$E$8)*OR(C OUNTIF(C$2:C2,C2)=1,COUNTIF(D$22,D2)=1)

    array entered in cell F2 using Ctrl-Shift-Enter so that the formula in the formula box will be surrounded by {}, with no cells merged in column F, copied down.

    That dancing banana is one groovy dude.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Star Lounger
    Join Date
    May 2002
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sum Function by Groups (Excell 2000)

    Thanks...It worked like a charm <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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