| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
spread sheets - adding
Allllen / Dave Peterson
You solved the problem. Thank you Ucha "UCHA" escreveu: How can I add the same cell of diverse contiguous spread sheets; example: (Pla1 H1 + Pla2 H1 + ...). the formula is: [=(Pla1!H1;Plan2!H1; ...)]; however, if I will add many spread sheets (50), the formula will be extremely great. How can I simplify the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding accross sheets in a workbook | Excel Worksheet Functions | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| how do i compare 2 spread sheets if the content of a cell is avai. | Excel Worksheet Functions | |||
| Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions | |||
Threaded Mode
