Data Aggregations' with Index and Matich

Hi,

I need to aggregate some non- adjacent columns into a consolidated report that is updatable. I am thinking index and match can solve my problem but I just cant seem to figure it out. I have attached a small sample workbook that is representative of my issue. I hope someone can help.

Chris

Hi
Try this :

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi Belinda200

Yes this works but...My true data table is 15 columns that need to be combined down to 8. These are non adjacent columns. Is their an easier way? May be a sumifs with index and Match....?

Chris

What were you thinking about? Please apply it to the file and let the forum help you fix the formula you came up with.

Anyway - here's without the offset:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.