| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sum all sheets
I have a workbook, with multiple sheets, each with it's own name. Each sheet
has a cell, ie N25, which represents a count function on that sheet. Now, I would like to place the sum of N25 of all the sheets on a summary sheet. Is it possible to do this with or without using a macro? If it is, I could use your help. Many thanks. Wally |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sum all sheets
=SUM(Sheet1:Sheet3!N25)
and adjust the worksheet names to match your needs. -- Gary''s Student - gsnu200785 "wally" wrote: I have a workbook, with multiple sheets, each with it's own name. Each sheet has a cell, ie N25, which represents a count function on that sheet. Now, I would like to place the sum of N25 of all the sheets on a summary sheet. Is it possible to do this with or without using a macro? If it is, I could use your help. Many thanks. Wally |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sum all sheets
Thanks for your suggestion, but as I said in the first sentence, "I have a
workbook, with multiple sheets, each with it's own name". Your suggestion will not do it. That is why I suggested something like =SUM(all sheets!N25). Wally "Gary''s Student" wrote: =SUM(Sheet1:Sheet3!N25) and adjust the worksheet names to match your needs. -- Gary''s Student - gsnu200785 "wally" wrote: I have a workbook, with multiple sheets, each with it's own name. Each sheet has a cell, ie N25, which represents a count function on that sheet. Now, I would like to place the sum of N25 of all the sheets on a summary sheet. Is it possible to do this with or without using a macro? If it is, I could use your help. Many thanks. Wally |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sum all sheets
We can make it work. I just created a workbook with three sheets:
alpha beta omega (where alpha is the first and omega is the last and beta is in the middle) =SUM(alpha:omega!N25) picks up ALL the sheets (even beta) ! just be sure you specify the first and last sheetname in the SUM() formula. Give it a try. -- Gary''s Student - gsnu200785 "wally" wrote: Thanks for your suggestion, but as I said in the first sentence, "I have a workbook, with multiple sheets, each with it's own name". Your suggestion will not do it. That is why I suggested something like =SUM(all sheets!N25). Wally "Gary''s Student" wrote: =SUM(Sheet1:Sheet3!N25) and adjust the worksheet names to match your needs. -- Gary''s Student - gsnu200785 "wally" wrote: I have a workbook, with multiple sheets, each with it's own name. Each sheet has a cell, ie N25, which represents a count function on that sheet. Now, I would like to place the sum of N25 of all the sheets on a summary sheet. Is it possible to do this with or without using a macro? If it is, I could use your help. Many thanks. Wally |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sum all sheets
For the OP, see also
http://www.rondebruin.nl/linksum.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gary''s Student" wrote in message ... We can make it work. I just created a workbook with three sheets: alpha beta omega (where alpha is the first and omega is the last and beta is in the middle) =SUM(alpha:omega!N25) picks up ALL the sheets (even beta) ! just be sure you specify the first and last sheetname in the SUM() formula. Give it a try. -- Gary''s Student - gsnu200785 "wally" wrote: Thanks for your suggestion, but as I said in the first sentence, "I have a workbook, with multiple sheets, each with it's own name". Your suggestion will not do it. That is why I suggested something like =SUM(all sheets!N25). Wally "Gary''s Student" wrote: =SUM(Sheet1:Sheet3!N25) and adjust the worksheet names to match your needs. -- Gary''s Student - gsnu200785 "wally" wrote: I have a workbook, with multiple sheets, each with it's own name. Each sheet has a cell, ie N25, which represents a count function on that sheet. Now, I would like to place the sum of N25 of all the sheets on a summary sheet. Is it possible to do this with or without using a macro? If it is, I could use your help. Many thanks. Wally |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Sum all sheets
"Gary"s Student"
Thanks, it does work and I appreciate your trying it out first. You guys do a great job. Wally "Gary''s Student" wrote: We can make it work. I just created a workbook with three sheets: alpha beta omega (where alpha is the first and omega is the last and beta is in the middle) =SUM(alpha:omega!N25) picks up ALL the sheets (even beta) ! just be sure you specify the first and last sheetname in the SUM() formula. Give it a try. -- Gary''s Student - gsnu200785 "wally" wrote: Thanks for your suggestion, but as I said in the first sentence, "I have a workbook, with multiple sheets, each with it's own name". Your suggestion will not do it. That is why I suggested something like =SUM(all sheets!N25). Wally "Gary''s Student" wrote: =SUM(Sheet1:Sheet3!N25) and adjust the worksheet names to match your needs. -- Gary''s Student - gsnu200785 "wally" wrote: I have a workbook, with multiple sheets, each with it's own name. Each sheet has a cell, ie N25, which represents a count function on that sheet. Now, I would like to place the sum of N25 of all the sheets on a summary sheet. Is it possible to do this with or without using a macro? If it is, I could use your help. Many thanks. Wally |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
| In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
Linear Mode
