ExcelBanter - #Value in FormulaArray

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - #Value in FormulaArray (https://www.excelbanter.com/excel-programming/439123-value-formulaarray.html)

#Value in FormulaArray

May thanks to those who have helped me in the past.

I have a macro that places the following formula in Cell C8, but I always
get a #VALUE error.

DevDev, DevQtr and DevCumSPW are defined column ranges on the DevData
Worksheet.

reportsSheet.Range("C8").FormulaArray =
"=SUM(If((RC[-2],DevData!DevDev)*(FilterControl!R33C12=DevData!Dev Qtr),DevData!DevCumSPW))"

What's weird is a similar formula always works correctly.

reportsSheet.Range("E9").FormulaArray =
"=MAX(IF((R[-1]C[-4]=PlanData!PlanDev)*(FilterControl!R33C12=PlanData! PlanQtr),PlanData!PlanSqft))"

Any ideas why ones working and the other isn't

#Value in FormulaArray

Have you checked that all of the range to be summed is numeric, no text
strings?

HTH

Bob

"RussellT" wrote in message
...
May thanks to those who have helped me in the past.

I have a macro that places the following formula in Cell C8, but I always
get a #VALUE error.

DevDev, DevQtr and DevCumSPW are defined column ranges on the DevData
Worksheet.

reportsSheet.Range("C8").FormulaArray =
"=SUM(If((RC[-2],DevData!DevDev)*(FilterControl!R33C12=DevData!Dev Qtr),DevData!DevCumSPW))"

What's weird is a similar formula always works correctly.

reportsSheet.Range("E9").FormulaArray =
"=MAX(IF((R[-1]C[-4]=PlanData!PlanDev)*(FilterControl!R33C12=PlanData! PlanQtr),PlanData!PlanSqft))"

Any ideas why ones working and the other isn't