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.

[Crooza]

Maybe this is all you need

Please Login or Register  to view this content.

[cazbaden]

Hi Crooza,

That worked like a charm. Thanks!

[avk]

Please Login or Register  to view this content.

[cazbaden]

Thanks avk. Replacing the variables works well.