Summing unknown number of duplicates in dataset

[jdmc45]

Hi,

I have a dataset, column A are ID numbers and column B are codes. When the is a duplicate ID and code from the next row, I want to sum a certain column C as many duplicates as there are. So for example, dataset could look like

A B C
123 abc 1
123 abc 4
123 bg 3
356 fh 5

I want to sum the 123, abc values in column C, that is, number 5. The problem is there isn't always just one duplicate but sometimes many, how would I go about this problem?

Thanks!

 

[mikerickson]

Try
=SUMPRODUCT(--(A1:A100=123), --(B1:B100="abc"), C1:C100)

or if you have Excel 2007 or later

=SUMIFS(C:C, A:A, 123, B:B, "abc")

 

[jdmc45]

Try
=SUMPRODUCT(--(A1:A100=123), --(B1:B100="abc"), C1:C100)

or if you have Excel 2007 or later

=SUMIFS(C:C, A:A, 123, B:B, "abc")

Thanks for that, but for the unique combination of ID and code the sum will be the same, is there a way to filter out the duplicate sum and return only one sum per unique combination of ID and code?

Cheers!

 

[mikerickson]

I don't understand your last question.
An example data set and result would help.