| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MAX figure within a date range as a function of today()'s date | Excel Worksheet Functions | |||
| HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ?? | Excel Worksheet Functions | |||
| HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ?? | Excel Worksheet Functions | |||
| Index function works in A2, but not in A10, Why is that? Cant figure it out. | Excel Worksheet Functions | |||
| Need formula to figure compound interest of a deposit for a year | Excel Worksheet Functions | |||
Linear Mode
