software

Im currently using the formula

=INDIRECT(quot;$BAquot;amp;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$4gt;=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: www.excelforum.com/member.php...oamp;userid=31337
View this thread: www.excelforum.com/showthread...hreadid=510169try using sumproduct, explained here
www.xldynamic.com/source/xld.SUMPRODUCT.html

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

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