Formula to copy column based on input

[CotoJoe]

I have a spreadsheet that shows budget amounts for each month. What I want to do is have one column that shows YTD budget amounts in one column based on inputting the month. In other words, if I put the month of Feb in the column, the formula or macro would sum Col A and B (assuming Col A holds budget data for Jan and Col B holds Feb). If I change the month, it would change the sum function.

I tried doing this with a custom formula but couldn't get it to work. Any ideas?

Coto Joe

 

[dannac]

Thread below may give you an idea how to do it :

http://www.mrexcel.com/forum/showthread.php?t=421543

 

[mikerickson]

If your month ("Feb") is in M1

=SUM(OFFSET($A$1,0,0,COUNTA($A:$A),MATCH(M1,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0)))

should work