I'm having difficulty getting a sum of the contents of a cell that appears in
multiple worksheets in my workbook. It returns a VALUE error. It is:

=SUM(Master!Q2:'Week 1'!Q2)

where Master and Week 1 are the sheet names (with a Week 2 in between them).
I've also tried it with worksheets without an intervening one (i.e. summing
Q2 in weeks 1 and 2 worksheets), with the same VALUE error.

Am I doing it incorrectly, or does SUM not work across worksheets the same
way it does within a worksheet, and then, if so, what other alternative do I
have?

I know I can just use the =A+B+etc. function, but I don't want to have to
edit the workbook's summary function every time an intervening worksheet is
added.

Thanks!

--

John Reimer