Looking at several columns with Indirect

[Toon]

Im currently using the formula

=INDIRECT("$BA"&ROW())

which is named DataColumn. However, I need to use it to look at columns BA through BE, and still be within the name of DataColumn. The whole formula that DataColumn is nested in is

=IF($R$4>=ThisMonth,IF(ISERROR(DSUM(HB_VE_DataSet,DataColumn,AusCriteria)),0,DSUM(HB_VE_DataSet,DataColumn,AusCriteria)),0)


Everything works fine, but I recently figured out that there are values I need in the columns BA through BE, and not just BA like I initially thought. How can I get it to look at all 5 columns?

[Bob Tarburton]

try using sumproduct, explained here
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

not enough info in your post for me to figure out your conditions for
expanding the range.

"Toon" <[email protected]> wrote in message
news:[email protected]...
>
> Im currently using the formula
>
> =INDIRECT("$BA"&ROW())
>
> which is named DataColumn. However, I need to use it to look at columns
> BA through BE, and still be within the name of DataColumn. The whole
> formula that DataColumn is nested in is
>
> =IF($R$4>=ThisMonth,IF(ISERROR(DSUM(HB_VE_DataSet,DataColumn,AusCriteria)),0,DSUM(HB_VE_DataSet,DataColumn,AusCriteria)),0)
>
>
> Everything works fine, but I recently figured out that there are values
> I need in the columns BA through BE, and not just BA like I initially
> thought. How can I get it to look at all 5 columns?
>
>
> --
> Toon
> ------------------------------------------------------------------------
> Toon's Profile:
> http://www.excelforum.com/member.php...o&userid=31337
> View this thread: http://www.excelforum.com/showthread...hreadid=510169
>