| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
USE CONCATENATE function to connect 2 formulas
Is there a way to combine two formulas in adjecent cells into one single
formula? It is important that the resulting cell contains the formula that is in each of the source cells summed together. It can not be simply a new function that adds the 2 cells together. EG. CELL A1 contains the formula: =Sum(A2:A100) Cell B1 Contains the formula: =Sum(B2:B100) New cell in C1 must contain the formula =Sum(A2:A100)+Sum(B2:B100). Thank you, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| clock | Excel Worksheet Functions | |||
| Informatica Connect to Excel workbook | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Threaded Mode
