Index/Match but for many locations?

[TAG423]

I have a spreadsheet that is similiar to this example:

Column C Column D Column E Column F Column G Column H ......
AN1234 25 AN1234 32 AN9876 21
AN3432 20 AN9876 20 AN1234 10

I need to sum each unique number from columns C,E,G, and so on with the result number from D, F, H, ....

Result needed:
AN1234 67
AN9876 41
AN3432 20

There are many rows and many columns. Do I need a database within excel. I don't have ACCESS knowledge so I need to stay with Excel.

Any suggestions or do you need more information?

Thanks.

 

[wigi]

Hello

You could copy the columns below each other, and then run a simple pivot table on the "full" table. Should be done in a nick of time. Much better approach than using expensive functions.

 

[TAG423]

The message didn't turn out the way I wrote it.

Column C = AN1234, AN3432
Column D = 25, 20
Column E = AN1234, AN9876
and so on.

 

[wigi]

The message didn't turn out the way I wrote it.

Column C = AN1234, AN3432
Column D = 25, 20
Column E = AN1234, AN9876
and so on.

So in this example you assume 2 rows are filled, for columns C, D, E?

 

[mikerickson]

SUMIF works with rectangular ranges

=SUMIF(C1:G100, "AN1234", D1:H100)