| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for adding 2 worksheets
I need to consolidate 2 worksheets on another separate sheet. What kind of
formula can I write that would include new names on the 2nd worksheet. Say, the 1st sheet has 5 names with values, the 2nd sheet has these same names with 3 new names with values, I need to include on one sheet a total of 8 names with values values from 2 worksheets... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for adding 2 worksheets
This should work . . .
=SUM(Book3!TestName,Book2!TestName) (This assumes the workbooks are in the same directory.) Rich "accountant" wrote: I need to consolidate 2 worksheets on another separate sheet. What kind of formula can I write that would include new names on the 2nd worksheet. Say, the 1st sheet has 5 names with values, the 2nd sheet has these same names with 3 new names with values, I need to include on one sheet a total of 8 names with values values from 2 worksheets... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the formula for adding a group of worksheets together? | Excel Worksheet Functions | |||
| adding worksheets | Excel Discussion (Misc queries) | |||
| 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) | |||
| adding worksheets together | Excel Discussion (Misc queries) | |||
Linear Mode
