Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM Question
I have a Workbook containing multiple Worksheets. Each Worksheet has the same
number of Columns but different number of rows. The last row of each Worksheet contains the Sum for each Column. Is there a formula that will SUM all of a given Column's totals for all Worksheets, even though the number of rows is different in each Worksheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM Question
It would be much easier if you put your total in row 1 and then sum across
row 1. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "lanrcdd" wrote in message ... I have a Workbook containing multiple Worksheets. Each Worksheet has the same number of Columns but different number of rows. The last row of each Worksheet contains the Sum for each Column. Is there a formula that will SUM all of a given Column's totals for all Worksheets, even though the number of rows is different in each Worksheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM Question
How about placing the SUM() function at the *top* of the column, just under
the header, and then you'll have the same cell on each sheet to use for totaling. =SUM(Sheet1:Sheet15!A3) -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "lanrcdd" wrote in message ... I have a Workbook containing multiple Worksheets. Each Worksheet has the same number of Columns but different number of rows. The last row of each Worksheet contains the Sum for each Column. Is there a formula that will SUM all of a given Column's totals for all Worksheets, even though the number of rows is different in each Worksheet? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM Question
In , RagDyeR
spake thusly: How about placing the SUM() function at the *top* of the column, just under the header, and then you'll have the same cell on each sheet to use for totaling. =SUM(Sheet1:Sheet15!A3) In case the OP still doesn't want to move the SUM(), though, this would work as one way, assuming there are no blanks in the column data: =SUM(OFFSET(Sheet1!B1,COUNTA(Sheet1!B:B)-1,),OFFSET(Sheet2!B1,COUNTA(Sheet2!B:B)-1,)) (Assumes the column we're interested in here is B and there are two sheets.) -dman- ============================================ "lanrcdd" wrote in message ... I have a Workbook containing multiple Worksheets. Each Worksheet has the same number of Columns but different number of rows. The last row of each Worksheet contains the Sum for each Column. Is there a formula that will SUM all of a given Column's totals for all Worksheets, even though the number of rows is different in each Worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Newbie With A Question | Excel Worksheet Functions | |||
Anybody Help with previous question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |