#Value in FormulaArray

  • Thread starter Thread starter RussellT
  • Start date Start date
R

RussellT

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!DevQtr),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
 
Have you checked that all of the range to be summed is numeric, no text
strings?

HTH

Bob
 
Back
Top