Hi /Torsorq,
You might want to reconsider your requirements after reading
http://groups.google.com/groups?as_u...2@TK2MSFTNGP10

Slow Response, Memory Problems, and Speeding up Excel
http://www.mvps.org/dmcritchie/excel/slowresp.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"RagDyeR" wrote in message ...
Well ... reacting "generally" ... If you attempted to add (Sum() ), the
running total column that contained those zero length strings ( "" ), you
would get an accurate total, with *no* error messages.

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"noyb" wrote in message
...
My apologies, I was actually reacting generally to the fact that Excel
does not handle the results of a formula which resolves to "" very well
and not to this specific question.

Ragdyer wrote:
The OP asked that "no number" be present until a value was entered in
Column A.

What are your specs?
Can you accept a zero?

=IF(A1,SUM($A$1:A1),0)

Also, exactly what formula are you using, and in what way are you using
it, that's giving you an error?

There might be viable "workarounds".