# Thread: Sum Function by Groups (Excell 2000)

1. ## 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.

2. ## 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

3. ## 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.

4. ## 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
•