SUM multiple Worksheets

[Anthony G.]

Hello to All:

I have a Workbook with 10 Worksheets and I want to add an 11th or Summary Sheet. Being that the row/column structure in all sheets are identical, I do recall a way in which I can sum the range of all the sheets for each cell: for example, SUM(Sheet1!A1:Sheet10!A1) – the result would be a SUM of cells A1 for all 10 sheets…but I appear to be missing something because I keep getting the #VALUE! Error.

Any assistance would be greatly appreciated.

Anthony

 

[nbrcrunch]

you were very close

=SUM(Sheet1:Sheet10!A1)

 

[Anthony G.]

Awesome...Thanks!!

Anthony