StewartCooke
New Member
- Joined
- Mar 3, 2002
- Messages
- 48
Hi
Can anybody tell me whether it's possible to sum a cell in a number of sheets using the indirect function.
i.e Sheets from "Jan" to "Dec"
User input puts from and to sheet names in cells A1 & A2 respectively.
If user inputs "March" and "August" I want all sheets between March and August summing.
I can currently get the indirect function to sum one sheet using the following formula:
=(INDIRECT(A1&"!"&"c5"))
This will give results for cell c5 of sheet specified in cell A1.
How can I pick up multiple sheets???
Can anybody tell me whether it's possible to sum a cell in a number of sheets using the indirect function.
i.e Sheets from "Jan" to "Dec"
User input puts from and to sheet names in cells A1 & A2 respectively.
If user inputs "March" and "August" I want all sheets between March and August summing.
I can currently get the indirect function to sum one sheet using the following formula:
=(INDIRECT(A1&"!"&"c5"))
This will give results for cell c5 of sheet specified in cell A1.
How can I pick up multiple sheets???