Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum problem
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formula - language needed | Excel Worksheet Functions | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
help please with conditional format problem | Excel Worksheet Functions |