Dear all,

Could anybody help to advise me the appropriate formula to draw a
year-to-date figure from a table. I have a worksheet storing expenses, I am
using INDEX function to draw the current month expense, but I don't know how
to set a formula to draw the accumulated figure of that month. For example,
if I choose feb (2) as current month, I would like to YTD column show the
sum of Jan & Feb.

Thanks in advance for your help.
et


Current Mth : 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

For the current month:

=INDEX(B6:F6,MONTH(TODAY()))

For YTD:

=SUM(B6:INDEX(B6:F6,MONTH(TODAY())))

Copy down as needed.

Biff

"et" wrote in message
...
Dear all,

Could anybody help to advise me the appropriate formula to draw a
year-to-date figure from a table. I have a worksheet storing expenses, I
am using INDEX function to draw the current month expense, but I don't
know how to set a formula to draw the accumulated figure of that month.
For example, if I choose feb (2) as current month, I would like to YTD
column show the sum of Jan & Feb.

Thanks in advance for your help.
et


Current Mth : 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

Dear Biff,

Thanks a lot. It works perfectly.

et

"T. Valko" l...
For the current month:

=INDEX(B6:F6,MONTH(TODAY()))

For YTD:

=SUM(B6:INDEX(B6:F6,MONTH(TODAY())))

Copy down as needed.

Biff

"et" wrote in message
...
Dear all,

Could anybody help to advise me the appropriate formula to draw a
year-to-date figure from a table. I have a worksheet storing expenses, I
am using INDEX function to draw the current month expense, but I don't
know how to set a formula to draw the accumulated figure of that month.
For example, if I choose feb (2) as current month, I would like to YTD
column show the sum of Jan & Feb.

Thanks in advance for your help.
et


Current Mth : 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

You're welcome. Thanks for the feedback!

Biff

"et" wrote in message
...
Dear Biff,

Thanks a lot. It works perfectly.

et

"T. Valko"
l...
For the current month:

=INDEX(B6:F6,MONTH(TODAY()))

For YTD:

=SUM(B6:INDEX(B6:F6,MONTH(TODAY())))

Copy down as needed.

Biff

"et" wrote in message
...
Dear all,

Could anybody help to advise me the appropriate formula to draw a
year-to-date figure from a table. I have a worksheet storing expenses, I
am using INDEX function to draw the current month expense, but I don't
know how to set a formula to draw the accumulated figure of that month.
For example, if I choose feb (2) as current month, I would like to YTD
column show the sum of Jan & Feb.

Thanks in advance for your help.
et


Current Mth : 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