| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is the formula for adding a group of worksheets together?
I am setting up monthly spread sheets for tax purposes. I have each month
set up separately and a total page. I want to know if you can put a formula in on the total page (which is a separate worksheet in my workbook) that will add up a single row from each worksheet an d give me a total for my total page. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the formula for adding a group of worksheets together?
Hi
Something like =SUM(Sheet2:Sheet3!B2:D2). Start the formula =SUM( ,then select the sheets you want and then the range. regards Peter "teeblackman" wrote: I am setting up monthly spread sheets for tax purposes. I have each month set up separately and a total page. I want to know if you can put a formula in on the total page (which is a separate worksheet in my workbook) that will add up a single row from each worksheet an d give me a total for my total page. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the formula for adding a group of worksheets together?
Does this work on all versions of MS Excel? And what if you change to the
name of the sheet do you put the new name of the sheet or do you still use Sheet 1: etc. "Billy Liddel" wrote: Hi Something like =SUM(Sheet2:Sheet3!B2:D2). Start the formula =SUM( ,then select the sheets you want and then the range. regards Peter "teeblackman" wrote: I am setting up monthly spread sheets for tax purposes. I have each month set up separately and a total page. I want to know if you can put a formula in on the total page (which is a separate worksheet in my workbook) that will add up a single row from each worksheet an d give me a total for my total page. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
What is the formula for adding a group of worksheets together?
A method that allows for changing sheet names.........
Insert a dummy sheet at beginning and a dummy sheet at end of sheets. Name these Start and End. Your formula would then be =SUM(Start:End!B2:D2) and encompass all sheets between no matter what the name or how many new sheets are inserted. Yes.....it works in all versions I can remember as far back as Version 5 Gord Dibben MS Excel MVP On Tue, 20 Mar 2007 11:14:23 -0700, teeblackman wrote: Does this work on all versions of MS Excel? And what if you change to the name of the sheet do you put the new name of the sheet or do you still use Sheet 1: etc. "Billy Liddel" wrote: Hi Something like =SUM(Sheet2:Sheet3!B2:D2). Start the formula =SUM( ,then select the sheets you want and then the range. regards Peter "teeblackman" wrote: I am setting up monthly spread sheets for tax purposes. I have each month set up separately and a total page. I want to know if you can put a formula in on the total page (which is a separate worksheet in my workbook) that will add up a single row from each worksheet an d give me a total for my total page. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I wish to group my worksheets under group tabs | Excel Worksheet Functions | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Formula for adding totals from separate worksheets | Excel Discussion (Misc queries) | |||
| How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions | |||
| adding to a group | Excel Discussion (Misc queries) | |||
Hybrid Mode
