INDIRECT Formula Issue

[clmsntgrs]

Why does this formula work:

=SUMIF(($BO$2:CP$2),DG$2,$BO$2696:CP$2696)


BUT this formula does not work:

=INDIRECT("(SUMIF(($BO$2:CP$2),DG$2,$BO$2696:"&ADDRESS(2696,94)&"))")


The second formula gives me a #REF! error.

I'm not seeing it.

Thanks.

 

[Snakehips]

I am not entirely sure what you are trying to achieve with your INDIRECT(), so I cannot offer a solution. You appear to have your formula as the text string argument of the INDIRECT function.
The argument must be a text string that references a cell or range that holds your required data.
Eg C3 has value A1 and A1 contains 123 then INDIRECT(C3) will return 123.

You can build up the text string in any way you like, including references to other sheets or even open workbooks. But it must reference a cell or range.

A quick Google should lead you to more comprehensive info on INDIRECT().

Otherwise please post more of an idea as to what you are trying to achieve.

 

[pgc01]

Hi

Try:

=SUMIF($BO$2:CP$2,DG$2,INDIRECT("$BO$2696:"&ADDRESS(2696,94)))

 

[clmsntgrs]

Thanks, PGC. That did the trick.

 

[pgc01]

I'm glad it helped. Thanks for the feedback.