How to sum up a Year-to-date figure by using INDEX
 

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

How to sum up a Year-to-date figure by using INDEX
 

good evening ET
Counting cells that meet multiple Criteria
Could look like this
=Sum(if((Month="January")*(Expence="Candybarscost" )*(Amount=3000)
Month, Expence, Amount are cell references
Remember to enter an array formula, Press Control+Shift+Enter not just enter.
=sum or =sumif

--
William<"M"




"et" wrote:

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

How to sum up a Year-to-date figure by using INDEX
 

Dear William,

Thanks.

et

"Sunday88310" ...
good evening ET
Counting cells that meet multiple Criteria
Could look like this
=Sum(if((Month="January")*(Expence="Candybarscost" )*(Amount=3000)
Month, Expence, Amount are cell references
Remember to enter an array formula, Press Control+Shift+Enter not just
enter.
=sum or =sumif

--
William<"M"




"et" wrote:

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