using INDIRECT within SUMPRODUCT

[geordz]

Hi there,
I recently had soem excellent help on using the indirect function however I am now trying to compute (in sheet1) the sumproduct of two arrays. One array is in sheet1 and the second is in a sheets called 'power'

I have tried
=SUMPRODUCT(B23:B48,INDIRECT("'"&$B$17$&"'!"&V80_power))

cell $B$17 in the working sheet 'sheet1' contains the name of the sheet 'power'. Within the sheet 'power' I have named the range I wish to use as 'V80_power' (It is the cells $B$3:$B$28).

However all I get in the cell I am trying to calculate this value is #ref

I hope soemone can help

dave

 

[GlennUK]

Try:

=SUMPRODUCT(B23:B48,INDIRECT("'"&$B$17$&"'!V80_power"))

 

[geordz]

Sorry for delay in replying but thank you very much for the help, much appreciated.

dave

 

[GlennUK]

My pleasure