Year to date problem

**bumpty** · 02-13-2012, 06:40 AM

Morning all
I would appreciate any help that you can provide me with the following problem

Please see attached file

I am trying to automate my budgets so when I input the month in Cell F4 on the acc tab then the highlighted Yellow Month and Highlighted Green YTD budget comes in reading from the 2nd Budget tab.

I have managed to solve the month one and by putting in Dec in F4 I get back the months budget of 300k but I can not seem to get the YTD to work ie for Dec it should be £500k

I have been looking at this now for a few hours and a fresh pair of eyes may help me solve what i am doing wrong

thanks

**zbor** · 02-13-2012, 06:47 AM

There's only one Dec and it's in 2011 and it's 300k. Why 500?

**bumpty** · 02-13-2012, 06:50 AM

it should add Nov and Dec to give me the YTD figure of £500k the £300k is going into the month ok but the YTD is not working just comes back as 0 - its the green cell M7

**bumpty** · 02-13-2012, 08:53 AM

is anyone able to assist me with this ?

**zbor** · 02-13-2012, 08:57 AM

I'm still not sure what you looking for.. There's lot of reference errors in your workbook...

Mayb, if you could write all years in Budget 2nd row (2011_2011_2012_2012_2012....._2012)

Then you could use: =SUMIF(budget!$B$2:$N$2, acc!M7, budget!$B5:$M5)

is that it?

**bumpty** · 02-13-2012, 09:14 AM

thanks but this only brings back the month not the total year to date amount
ie if I put Feb in cell F4 - I would expect
the month (F7) to be £500
The Year to date (M7) to be £1400

I have the month one working perfectly its just the YTD figure that I can not get to work - im not saying my formula is correct or the right one but im struggling to find another solution