Hi
=SUM('First:Last'!A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"CarlosAntenna" schrieb im Newsbeitrag
...
I have a workbook with multiple sheets.
The sheets are named "First", 1, 2, 3......., "Last" in that order.
On a summary sheet outside of that range I use the formula
=SUM(First!A1:Last!A1) and it gives a #VALUE error. Why?