I am using this formula to get a particular data from old book [=SUM(('G:\[november2007.xlsx]Sheet1'!W13))]. But every month need to change”month name” to get data from previous month. So Instead of this, I applied this in “CHOOSE FORMULA” as (=choose(a1,”=SUM(('G:\[december2007.xlsx]Sheet1'!W13))”), (=choose(a1,”=SUM(('G:\[january2008.xlsx]Sheet1'!W13))”), ………….. and so on for all 12 months. When I applied this formula, it will not working. How can I rectify the mistake or is there any alternative formula. Please help me. Thank you
2007-12-23
23:23:22
·
3 answers
·
asked by
saba
1
in
Software