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?