software

I am trying to use the following formula but I am getting the #VALUE! error:

=SUMPRODUCT(INDIRECT(quot;'quot;amp;F1:F4amp;quot;'!aquot;amp;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.

Try...

=SUMPRODUCT(N(INDIRECT(quot;'quot;amp;$F$1:$F$4amp;quot;'!A3quot;)))

Hope this helps!

In article gt;,
Steve gt; wrote:

gt; I am trying to use the following formula but I am getting the #VALUE! error:
gt;
gt; =SUMPRODUCT(INDIRECT(quot;'quot;amp;F1:F4amp;quot;'!aquot;amp;3))
gt;
gt; Cells F1 to F4 contains the names Amarillo, Advanced Med, Augusta, Bham
gt; which represent tab names within the worksheet. There are about 20 tabs but
gt; I only want to sum the ones that are in F1 to F4.
gt;
gt; Am I going about this wrong? Thanks.