Get ytd sum

[pphg]

Hi

Just need some help to get the YTD sum depending on the selected Item and Month.

For example, if selected Item 1 and month June, the formula will get the sum of Jan to June numbers from the data tab.

Please refer to the attached file for reference.


Many thanks!

[Andrew-R]

Give this a try:

=SUM(OFFSET(DATA!$C$3,MATCH($C$2,DATA!$B$4:$B$6,0),0):OFFSET(DATA!$B$3,MATCH($C$2,DATA!$B$4:$B$6,0),MATCH($C$3,DATA!$C$3:$N$3,0)))