View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Formula to automatically show running total

Your question is not too clear!

If you want a single cell, say F1, to display the present total of values in
Column E,
enter this in F1:
=Sum(E:E)

If you want Column F to display the totals in Column E, row by row,
enter this in F1:
=Sum(E$1:E1)
and copy down as needed.

If you *don't* want to see the totals duplicated down Column F,
where Column E is empty,
enter this in F1:
=IF(E1="","",SUM(E$1:E1))
and copy down as needed.

The above 2 formulas are *very* XL resource intensive, so don't use them in
excess of a thousand rows or so.

Post back if I misunderstood your question, or you need a *large* range to
be calculated.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"TexArty" wrote in message
...
Newbie hates to ask but I'm stuck in a rut. I am trying to automatically
show a running total in column F for all additional amounts listed in

column
E when I click in Column F.
Any and all advice will be greatly appreciated.