E
et
Hi all,
I have a file with quite a lot of worksheet storing different years
expenses. I use INDEX function to draw the figure of the month I want, but I
don't how to set a formula to draw the year-to-date figure of that month. If
I choose 2 (feb), the year-to-date figure should be Jan + Feb. Would you
please advise, thanks.
et
2
Exp Jan Feb Mar Apr May
Cur Mth YTD
Tel 100 101 110 98 102 =INDEX(B6:F6,2)
Rent 1000 1000 1000 1000 1000 1000
Entertainment 200 500 300 58 117 500
I have a file with quite a lot of worksheet storing different years
expenses. I use INDEX function to draw the figure of the month I want, but I
don't how to set a formula to draw the year-to-date figure of that month. If
I choose 2 (feb), the year-to-date figure should be Jan + Feb. Would you
please advise, thanks.
et
2
Exp Jan Feb Mar Apr May
Cur Mth YTD
Tel 100 101 110 98 102 =INDEX(B6:F6,2)
Rent 1000 1000 1000 1000 1000 1000
Entertainment 200 500 300 58 117 500