Group duplicate entries and sum the columns

[jdmc45]

Hi,

I have duplicate entries in Column A, for ID, so for instance

ColumnA - ID
12
12
13
14
15

As you can see there are duplicate entries. In Columns B and C I have prices, how would I go about grouping the duplicate rows and adding the values of the columns B and C of the resulting group?

Thanks so much for your help!

 

[jdmc45]

The advanced filter doesn't have this functionality, is there another way to do it, besides a pivot table? Thanks

 

[Aladin Akyurek]

Run Advanced Filter in order to get a distinct list say in F.

Then invoke in G2:

=SUMIF($A$2:$A$6,$F2,B$2:B$6)

and copy across.

 

[jdmc45]

Run Advanced Filter in order to get a distinct list say in F.

Then invoke in G2:

=SUMIF($A$2:$A$6,$F2,B$2:B$6)

and copy across.

That should work a treat, thankyou. Only thing is the list I want to do this to has values found using an ISERROR(INDEX(...)) type function, and when I try to use the advanced filter I get,

"The extract range has a missing or illegal field name"

If I copy and paste only the values of the list I can do the advanved filter however. I want the spreadsheet to be dynamic, why isn't the advanced filter working?

 

[jdmc45]

any advanced filter experts out there?

 

[jdmc45]

My question is how to do this all dynamically, so it all flows through from inputs to here? If I put another dataset (in the same format) into my spreadsheet I need it to automatically produce this table, how would I do this?

Thanks in advance for your time