| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing multiple tab using sumproduct function
I am trying to use the following formula but I am getting the #VALUE! error:
=SUMPRODUCT(INDIRECT("'"&F1:F4&"'!a"&3)) Cells F1 to F4 contains the names Amarillo, Advanced Med, Augusta, Bham which represent tab names within the worksheet. There are about 20 tabs but I only want to sum the ones that are in F1 to F4. Am I going about this wrong? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Summing multiple tab using sumproduct function
Try...
=SUMPRODUCT(N(INDIRECT("'"&$F$1:$F$4&"'!A3"))) Hope this helps! In article , Steve wrote: I am trying to use the following formula but I am getting the #VALUE! error: =SUMPRODUCT(INDIRECT("'"&F1:F4&"'!a"&3)) Cells F1 to F4 contains the names Amarillo, Advanced Med, Augusta, Bham which represent tab names within the worksheet. There are about 20 tabs but I only want to sum the ones that are in F1 to F4. Am I going about this wrong? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can you use multiple ranges in a function? | Excel Worksheet Functions | |||
| Using Sumproduct Function To Add Multiple Criteria | Excel Worksheet Functions | |||
| SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
| Sumproduct + Array Function? | Excel Worksheet Functions | |||
| Sum Indirect function through multiple sheets | Excel Discussion (Misc queries) | |||
Linear Mode
