Need Help! Conditional Summing

S

S.J. Powell

I am currently using the Conditional Sum function on a data range that
is 50 columns by 15,000 rows. After i pick my criteria to sum and
choose where i would like to place the result, I get a runtime error
stating "Unable to set FormulaArray property of range class." Can any
provide any information on how to resolve this- your help would be
greatly appreciated.
 
J

JulieD

Hi

no idea really, but we might be able to help you to construct a formula
directly into the cell if you'ld like to explain what the conditions are and
what range you want to sum.

Cheers
JulieD
 

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

Conditional sum in an array 11
Really need some help with a multi conditional SumProduct 1
Can I use conditonal sum and have results on a linked sheet? 2
Run Time Error '1004' 1
how do I sum currency values in a row containing currency and uni. 2
Conditional Sum without Range Parameters 5
Complex Conditional Sum 3
unable to set the formula array property of the range class 3

Top