Hi All

I have data in excel which I need a formaula which calculates the year to date position when a month number is changed. for example

Month
Jan Feb March April..... Dec
5 4 2 3 4

In a input box in excel cell (E4)
if 1 is entered into the box it would return 4 (jan)
if 2 is entered into the box it would return 9 (jan + feb)
...
if 4 is entered into the box it woulld return 14 (jan + feb+mar+april)

Thanks

Hope you can help