SUM multiple Worksheets

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
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,119,127
Messages
5,576,233
Members
412,709
Latest member
AD04
Top