Anthony G.
Active Member
- Joined
- Mar 24, 2002
- Messages
- 465
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
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