Just to add to Earl's excellent suggestion, I also tend to exactly the ame
thing, but instead of SUM i use SUBTOTAL.
That way, if I apply any Filters to the data, I see the total for just the
selected (visible) rows, but get the whole column total again as soon as I
take the filter off.
=SUBTOTAL(9,A5:A65536)
--
Regards

Roger Govier


"Earl Kiosterud" wrote in message
...
Kel,

One way is to put =SUM(A5:A65536) somewhere in A1 through A4 (this is an
example, where I've reserved rows 1-4 for heading stuff. Then freeze rows
1-4 (Window - Freeze pane) so it's always visible as you put more stuff in
the column(s) and start auto-scrolling down. Some people get all twitchy
and irritable at the thought of putting totals at the top, but it actually
works very well.

You don't want to use SUM(A:A) if the formula is actually in column A,
because the sum cell would be included in the cells being summed, causing
a circular reference.
--
Earl Kiosterud
www.smokeylake.com

"kelmonster" wrote in message
...
Does anyone know how I can set up a sum feature from the top row and have
it
calculate all the numbers in the column as I enter them without have to
highlight the entire col. when I enter =SUM(...)? Is there a formula I
can
enter? Right now I'm having to enter=SUM(highlight the entire column).
--
kel