| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Formulation with lots of sheets
I have an Excel workbok , that contains lots of sheets. Each have the same
structure. Ex. data1 to datai and i is up to 100 Is it possible to write a formula like that ? If datai'!A1=150 sum datai'B1 Sum all B1's of all sheets that has datai'!A1=150 condition. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print 1st Page Multiple Sheets in Same Workbook | Excel Discussion (Misc queries) | |||
| copying the same cells from many sheets | Excel Worksheet Functions | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| Need dynamic table_array formula that looks in different sheets | Excel Worksheet Functions | |||
Threaded Mode
