| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to set for adding total by month
Could anyone can help if I need to sum "exp1" & "exp2" by refering to column
up to cell to be inputed in separated cell. eg. C1 in this case cell to input feb (cell C1) jan feb mar xxx exp 1 100 300 500 exp 2 200 400 600 xxx xxx -- aw |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to set for adding total by month
Look at INDIRECT in help.
-- __________________________________ HTH Bob "aw" wrote in message ... Could anyone can help if I need to sum "exp1" & "exp2" by refering to column up to cell to be inputed in separated cell. eg. C1 in this case cell to input feb (cell C1) jan feb mar xxx exp 1 100 300 500 exp 2 200 400 600 xxx xxx -- aw |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| averaging a total out over a month | Excel Discussion (Misc queries) | |||
| 12 month Rolling Total | Excel Worksheet Functions | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| Sum total formula for adding 2 columnson time sheet | Excel Worksheet Functions | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
