Conditional Sum problem

J

Joel

I am linking conditional summary formulas using Excel 2000 in one worksheet
to data in another worksheet. However, I am getting the following error
message: "Run-time error 1004; unable to set the FormulaArray property of
the Range class." I have counted the characters in the correct formula and
they total 180 -- not over 255.

A) I was successful in getting these formulas to work a few days ago. Why
am I now getting this error message?
B) Is there a way to edit a conditional summary formula? I have been
unable to change even one character in the formula without using the Wizard.
 

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

VSTO C# add in Outlook.Appointment error 0
Weighted % Complete calculation 1
Conditional Formatting - Cannot get it to work, please help 1
Conditional Sum Wizard Limited Conditions 0
unable to set the formula array property of the range class 3
Sum of values in column A based on 0/1 of column B 2
Conditional formula yeilds non-number result 6
Copy formula from one worksheet to another to get value in 2nd wks 2

Top