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.