Thread
:
Create a running totaol
View Single Post
#
9
Sandy Mann
Posts: n/a
Create a running totaol
"Sandy Mann" wrote in message
...
Don Guillett" wrote in message
... Meant to copy down. Look
again
$a$1:a1
So it does. My apologies to RagDyeR
Or should I say my apologies to your client <g
--
Sandy
Replace@mailinator with @tiscali.co.uk
"Sandy Mann" wrote in message
...
Don Guillett" wrote in message
... Meant to copy down. Look
again
$a$1:a1
So it does. My apologies to RagDyeR
--
Sandy
Replace@mailinator with @tiscali.co.uk
"Don Guillett" wrote in message
...
Meant to copy down. Look again
$a$1:a1
--
Don Guillett
SalesAid Software
"Sandy Mann" wrote in message
...
"RagDyeR" wrote in message
...
Try this for a non-volatile suggestion:
=IF(A1,SUM($A$1:A1),"")
I assume that you mean to copy the formula down or you meant
=IF(A1,SUM(A:A),"") which would be fine if there was no other numbers in
column A.
If you meant copy down and the OP had say, 4,000 rows of data, would
that
not be more of a calculation load than a volatile function? Of course
it
would depend on what the rest of the sheet was like.
--
Regards
Sandy
Replace@mailinator with @tiscali.co.uk
Reply With Quote