SUM with INDIRECT ?

[vumian]

Dear all,

I have many sheets contain number only, with the same structure, same address at row and column

how i can use Sum, Indirect fucntions to sum all, combine with dynamic sheet name

sampling :
- i name 3 sheet as 1, 2 ,3
- i make the validation list with 1,2,3 at A1
- The number table at 3 sheets start at A10 to C15
now i can sum 3 table as function below : sum('1:3'!A10), then drag and drop down to C15

??? i want to use sum with how many sheet i want, it means the number 3 above must dynamic when i choose at A1

Thanks in advance,

[all4excel]

Try this solution provided to me by Vane0326..
http://www.excelforum.com/showthread.php?t=611112

Dear all,

I have many sheets contain number only, with the same structure, same address at row and column

how i can use Sum, Indirect fucntions to sum all, combine with dynamic sheet name

sampling :
- i name 3 sheet as 1, 2 ,3
- i make the validation list with 1,2,3 at A1
- The number table at 3 sheets start at A10 to C15
now i can sum 3 table as function below : sum('1:3'!A10), then drag and drop down to C15

??? i want to use sum with how many sheet i want, it means the number 3 above must dynamic when i choose at A1

Thanks in advance,