Indirect within sumproduct

[sadavies2906]

I have the following formula but want to use INDIRECT function on the column name within the table GANNT so becomes easier to update

=IF(F$7<$C$2,0,SUMPRODUCT(--(GANTT[WK40_2]=$B$11))*E$8)

Have tried the following but get a #REF

=IF(E$7<$C$2,0,SUMPRODUCT(--(INDIRECT("GANNT["&$J7&"_"&E9&"]")=$B$11))*E$8)

Where

J7= WK40
E9 = 2

Cheers
Stephen

 

[pgc01]

Hi Stephen

You mistyped GANTT in the second formula.