Dynamic totals on Budget vs Actual

[threehorn]

My spreadsheet has monthly columns, three columns per month: Budget, Actual, Difference. (plus a separator column between months)

I currently have the TOTAL columns summing all of the columns for each heading (ie. my Total Budget is the sum of all of the budget column cells for that row) BUT I want to enter my budget for the whole year, and this will make my TOTAL Actual Year to Date, but my TOTAL Budget be the entire year.

So i would like to select a month in a cell above the Total columns, and have the spreadsheet dynamically sum all of the columns up to that month.



Can you help?

THanks!

[jewelsharma]

see attached. Minor changes to layout (refer Row 2).

[threehorn]

What would i do if I needed to choose any monthly range (ie. if month one wasn't always the starting point, say I wanted to look at Mar through May, etc.)?

[shukla.ankur281190]

If you are looking month to month .

First create a drop down list as I created in attached file on cell no AX3 and AY3

AW7=IF(A7="","",SUMPRODUCT((IF($A$4:$AU$4="",0,("1"&$A$4:$AU$4&"-"&$A$3:$AU$3)+0)>=("1"&$AX$3)+0)*(IF($A$4:$AU$4="",0,("1"&$A$4:$AU$4&"-"&$A$3:$AU$3)+0)<=("1"&$AY$3)+0)*($A$5:$AU$5=AW$5)*($A7:$AU7))) with CRTL+SHIFT+ENTER and drag down..

Check the attached file.

P.s I did fill the whole month and year blank cells with respective months.

[threehorn]

Wow!

Thanks to both of the solutions! Very cool! I appreciate it greatly!