Lookup and sum values based on table headers

[enterthe]

I have the following table:

excel.PNG

What formula should I used under Cumulative actual and budget so it returns the sum of respective actual and budget figures (from the table on the right) up to the given month (in the first row).

[zbor]

Write this in AE7 and extend down and right:

Please Login or Register  to view this content.

[enterthe]

Great! :D But how can I add the additional condition of the month? This will just pick all actual values. The month is a drop down and so this should stop till the month selected... hence showing cumulative values till that month only.

[zbor]

Here, try this:

Please Login or Register  to view this content.

[enterthe]

Worked great for the actual value but gave wrong value for the budget when i moved it there

[enterthe]

Ok just got it... It worksSSS!! Thank you. :D