SUMIF query, possibly...?

I have two tables, the first contains data arranged as described,

The Column A contains a list of items, some of which are duplicated (this is necessary). Columns B, C, D etc. contains numeric data for each of these items. Columns B, C, D etc. have user nominated numeric ID's i.e. 1, 2, 3; any of these columns may end up with the same ID No.

I then have a separate table which I need to use to consolidate the sum of the values against each item, BUT these need to be grouped by Column ID i.e. if columns B - D all have the same ID "1", then I want the sum of the values of each items across the range of columns with the ID of "1".

Can anyone help?

Tuph

I have attached a much simplified copy of a worksheet showing what is required. Hopefully you can do something with it. The actual worksheet could have any number of rows and/or columns.

Thanks,

That's along the right lines. HOWEVER, in my haste to post I forgot one IMPORTANT addtional piece of info.

The list of items in Column A will & has to contain duplicate entries, so a two pronged approach is required, the result has to be a consolidated value, then grouped by column ID.

I have attached a revised example...

How would this work...?

Worked like a dream, BRILLIANT!!

Thanks,