Indirect Function

[mario92]

Hi,
Im trying to use the indirect function to be able to quickly change the columns it references in the formula below. for example, i would like something like =Product(IF((indirect C1..... where C1 has another letter instead of A to allow the formula to switch the columns it references without have to change the formula every time

=PRODUCT(IF(($A$11:$A$1790 >=DATEVALUE("11/18/2019"))*($A$11:$A$1790 <=DATEVALUE("11/20/2020")),$C$11:$C$1790))-1

Any help would be greatly apprciated.

 

[footoo]

The construction should be like this :
=SUM(INDIRECT("$" &$C$1&"$11:"&"$" &$C$1&"$1790"))

Just amend your formula accordingly.