ExcelBanter - Summing multiple tab using sumproduct function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Summing multiple tab using sumproduct function (https://www.excelbanter.com/excel-worksheet-functions/87160-summing-multiple-tab-using-sumproduct-function.html)

Steve

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.

Domenic

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.

All times are GMT +1. The time now is 03:01 AM.