There are numerous ways to edit a range of formulas.

Post your formula, and the formula locations for suggestions.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"lloyd8156" wrote in message
...
i have setup about 900 conditional sums but when i set up the range i set
it
for 3500 rows i need to change it to 9999 rows but when i try to edit the
formula on the toolbar from 3500 to 9999 it returns a value of 0 i really
dont want to go through the wizard ( conditional sum 900 times) to adjust
it
is there an easier way!!!!.