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,Data Column,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