Using SUM, INDEX & MATCH

[cazbaden]

Hi experts.

If you can, please help.

I have a table (included in the attachment) where I want to match the the date to a specific column in the table, and then sum all the values in the row up unto where the columns intersect.

The current formula returns the Actual value where H3 matches the column Q7 and intersects with the Range called Actual.

I hope this makes sense.

Here is what I have done:

Formula is in D9:
=SUM(INDEX(Actual,MATCH($H$3,Dates)))

Actual Range is row E9:AC9
Date Range is row E7:AC7

Any help will be highly appreciated.