sadavies2906
New Member
- Joined
- Feb 5, 2011
- Messages
- 45
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
=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
