Never said it would be faster or better, just an observation of an
alternative approach.
--
Regards,

RD

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

"David McRitchie" wrote in message
...
Guess I picked the name from the wrong thread in a previous message.
Appears that one involved counting instead of a total.

Why would index work faster or make more sense than
offset of one row up from a cell on the current row.


"RagDyer" wrote in message
...
BTW, who's Torsorq?<g

Anyway, very enlightening David.
When you come right down to it, it's really quite logical that
=Sum($A$1:A1)
Does really create a monster calculation job.

One doesn't think about it when referencing several hundred rows.

I don't think I'll suggest it again ... at least not without a caveat as
to
the size of the calculation.

However, one might try this:

=INDEX($B$1:$B$20000,ROW()-1)+A2

In place of this:

=OFFSET(B2,-1,)+A2

As far as I can tell, they're about the same speed ... for calculation
....
as well as deletion.

But I must admit, that the Offset does "look" cleaner then the Index,
Just as the =Sum($A$1:A1)
Looks cleaner then the Offset.
--
Regards,

RD


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

--------------------------------------------------------------------------
-


"David McRitchie" wrote in message
...
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".