ExcelBanter - formula to set for adding total by month

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula to set for adding total by month (https://www.excelbanter.com/excel-discussion-misc-queries/209794-formula-set-adding-total-month.html)

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

Bob Phillips[_3_]

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

All times are GMT +1. The time now is 02:02 AM.