Group Excel table and get the sum

[udaya726]

I have an Excel table whose unique key is the combination of Para1, Para2 and Para3:

Para1 Para2 Para3 Value1 Value2 Value3
A B C 1 2 3
A E F 4 6 4
A B C 5 3 7
P Q R 4 2 4

I want to find the duplicates and SUM the values, so the expected output is:

Para1 Para2 Para3 Value1 Value2 Value3
A B C 6 5 10
A E F 4 6 4
P Q R 4 2 4

Is there a way to group the data get the SUM?

[oeldere]

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[MickG]

Try this:-
NB:- This code will alter your Data !!!
Nb:- The code assumes your Actual Data starts in "A2"

Please Login or Register  to view this content.

Regards Mick