If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I get the sum total of all sheets in a workbook?
I have a 52 sheet workbook, all sheets have the same number of columns and
data. What do I need to do to arrive at the sum total of all these sheets without printing them all out and adding them up manually? Thanks in advance for your assistance. |
#2
|
|||
|
|||
Ortega, try something like this
=SUM(Sheet1:Sheet52!A1) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "OrtegaGroup" wrote in message ... I have a 52 sheet workbook, all sheets have the same number of columns and data. What do I need to do to arrive at the sum total of all these sheets without printing them all out and adding them up manually? Thanks in advance for your assistance. |
#3
|
|||
|
|||
can't you just have a new excell sheet and copy the total
on to that from each sheet. The formula should be okay since you are just adding columns and then just copy the totals to the new page. There is an update options or function but not sure haven't used it for a long time. -----Original Message----- I have a 52 sheet workbook, all sheets have the same number of columns and data. What do I need to do to arrive at the sum total of all these sheets without printing them all out and adding them up manually? Thanks in advance for your assistance. . |
#4
|
|||
|
|||
Try this -
On Sheet 1, use the formula =SUM(Sheet2:Sheet52!A1) where A1 is the value you are summing. Another way is creating a new Workbook (workbook2), which will read the source wookbook (workbook 1). =SUM([Book1]Sheet2:Sheet52!$A$1) I hope this helps Ruan wrote in message ... can't you just have a new excell sheet and copy the total on to that from each sheet. The formula should be okay since you are just adding columns and then just copy the totals to the new page. There is an update options or function but not sure haven't used it for a long time. -----Original Message----- I have a 52 sheet workbook, all sheets have the same number of columns and data. What do I need to do to arrive at the sum total of all these sheets without printing them all out and adding them up manually? Thanks in advance for your assistance. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Work Sheets | Daniell | Worksheet Functions | 4 | January 26th, 2005 02:08 AM |
Can't work formulas in sheets copied from the web | Gord Dibben | Worksheet Functions | 0 | May 2nd, 2004 12:53 AM |
Work Time Sheets and Wages | AJakubisin | Worksheet Functions | 2 | January 11th, 2004 12:27 AM |
Unhiding work sheets | Kevin Stecyk | Worksheet Functions | 2 | November 4th, 2003 10:58 PM |
Linking Work Sheets | Troy | Worksheet Functions | 3 | October 28th, 2003 10:16 AM |