FormulaArray

All:

I have the following code that runs without errors; however, the results are not what I was expecting.

Here is what is returned as an array: =SUM(IF("Anderson 31-12"=$G$3:$G$226,IF(1/1/2011<=$I$3:$I$226,IF(1/31/2011>=$I$3:$I$226,1,0)*$H$3:$H$226,0)))

The Bold text will not calculate in Excel. Therefore I presume my equation syntax for ForumlaArray is incorrect. But I have yet to figure it out.

The FormulaArray equation is an attempt to duplicate the formula below. It works fine in Excel.

SUM(IF($L3=$G$3:$G$226,IF(M$2<=$I$3:$I$226,IF(EOMONTH(M$2,0)>=$I$3:$I$226,1,0)*$H$3:$H$226,0)))

Any advice on how to get this to work, would be greatly appreciated.

Please Login or Register  to view this content.

All:

Here is the answer to my question earlier. I needed to add .Address to two of my inputs.

Please Login or Register  to view this content.