| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Formulation with lots of sheets
In your formula sumproduct formulation is used for summing over different
worksheets . When I need to sumproduct two variables B1 and C1 in these sheets , should I use that formula or is there a shorter way ? =SUMPRODUCT(SUMIF(INDIRECT("'"&F1:F100&"'!A1"),"15 0",INDIRECT("'"&F1:F100&"'!B1")),SUMIF(INDIRECT("' "&F1:F100&"'!A1"),"150",INDIRECT("'"&F1:F100&"'!c1 "))) |
| 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
