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