Sum of cells in different sheets

[Albert 1]

If I want the sum in sheet1-sheet20 of all values in A9, I can use:
=SUM(Sheet1:Sheet20!A9).
But if I want only the sum of A9 in the sheets 1, 3, 7, 14, 20, is there a shorter way than:
=(Sheet1!A9+Sheet3!A9+Sheet7!A9+Sheet 14+Sheet20!A9) ?
If this is not possible with a formula, I would have a macro that gives the sum of the values in all selected cells on different sheets.
Thanking you in advance.

[Mark W.]

Can you reorder these sheets so they are adjacent?

[ This Message was edited by: Mark W. on 2002-04-26 13:36 ]

[Aladin Akyurek]

On 2002-04-26 13:22, Albert 1 wrote:
If I want the sum in sheet1-sheet20 of all values in A9, I can use:
=SUM(Sheet1:Sheet20!A9).
But if I want only the sum of A9 in the sheets 1, 3, 7, 14, 20, is there a shorter way than:
=(Sheet1!A9+Sheet3!A9+Sheet7!A9+Sheet 14+Sheet20!A9) ?
If this is not possible with a formula, I would have a macro that gives the sum of the values in all selected cells on different sheets.
Thanking you in advance.

You don't need the outer parens, but that's all you can get qua abbreviation.

Aladin

[croweld89]

Forward looking...

There have been posts and I've had problems myself with deleting information from equations with (+) either excessive use of in the same or seperate worksheets. It is really ideal to continue to use the sum equation if at all possible.

FYI
-Dave

[Albert 1]

On 2002-04-26 13:35, Mark W. wrote:
Can you reorder these sheets so they are adjacent?

Unfortunately, no.

[Albert 1]

Thank you all for the quick response and the answers.