With your data starting in B2 (for KPI A) in sheet "Budget" then in your
summary "CUM YTD" for "KPI A" put:


=SUM(OFFSET(INDIRECT("B" &MATCH(A2,Budget!$A$1:$A$100,0)),0,0,1,$X$1))

X1 contains number of months
A2 contains "KPI A"
B2 will have cum. ytd target for KPI A

HTH

" wrote:

Hi
I have a budget sheet with the following

KPI Apr May Jun Jul
KPI A 20 21 25 27
KPI B 44 22 33 22

I then have a summary sheet with the following
Report Month : (user enters report month number)

KPI Cum. YTD Target Cum. Actual Annual Target
KPI A (formula A) (formula B)
(formula C)
KPI B (formula A) (formula B)
(formula C)

What I need is formula A.I would like to be able to get the cumulative
YTD total based on the report month entered by the user.
For example if the user enters 2 as the report month, then the cum YTD
total for KPI A should show as 20+21=41.

How can I achieve this? I have thought of using sumif, but I cant work
out how to combine it with a lookup or maybe there is a better way to
achieve the result.