Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUM with INDIRECT function
Hi,
I have the following formula =SUM(January!BM9,February!BM9,March!BM9,April!BM9, May!BM9,June!BM9,July!BM9,August!BM9,September!BM9 ,October!BM9,November!BM9,December!BM9) Which works fine but I would like to shorten it. I have a sheet called Data with a list of the months in range A13:A24 and I was wondering if I could use the INDIRECT function instead?? If so can you please provide the correct formula for the above. Thanks in advance, Gav |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
indirect function | Excel Discussion (Misc queries) | |||
How to use indirect function? | Excel Discussion (Misc queries) | |||
indirect function | Excel Worksheet Functions | |||
INDIRECT function inside AND function | Excel Worksheet Functions | |||
Indirect Function and Sum | Excel Worksheet Functions |