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.