#Value in FormulaArray

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
 
B

Bob Phillips

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

HTH

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use count data in formula 1
FormulaArray 1
Adding arrays 1
#VALUE! in cell 4
VBA Code To have a macro repeat on all sheets in a workbook 3
Value transfered to cell differs from value in record set 2
Macro Instability 4
using the value of a macro variable in a concatenate formula 4

Top