problems with obtaing month and YTD amounts with index & Match

[bumpty]

Morning all

I am not getting the correct results return on the attached sheet can any one assist as to what I have done wrong on my formula

There are two tabs - first tab is reading from the second - I am trying to get the month Plan and YTD plan to return by changing the date in cell B1 on the first tab

I am getting a result but not the correct ones

appreciate it if anyone can spot my mistakes !!!

thanks

[DonkeyOte]

Either:

J9:
=SUM(INDEX('london plan'!$C$4:$C$31,MATCH($C9,'london plan'!$A$4:$A$31,0)):INDEX('london plan'!$C$4:$N$31,MATCH($C9,'london plan'!$A$4:$A$31,0),MONTH(1&$B$1)))
copied down

or

J9:
=SUM(OFFSET('london plan'!$C$4,MATCH($C9,'london plan'!$A$4:$A$31,0)-1,0,1,MONTH(1&$B$1)))
copied down

the latter is volatile unlike the former (semi volatile)

Regards your PLAN month column:

F9:
=INDEX('london plan'!$C$4:$O$31,MATCH(C9,'london plan'!$A$4:$A$31,0),MONTH(1&B$1))
copied down

or

=SUMIF('london plan'!$A$4:$A$31,$C9,INDEX('london plan'!$C$4:$O$31,0,MONTH(1&B$1)))
copied down

I prefer the latter.

[bumpty]

thanks that works