| 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 |
| 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 | |||
Threaded Mode
