Sum from top

[kelmonster]

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

[Paul Sheppard]

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

Hi kel

Try Sum(A2:A65536)

[Dave Peterson]

I'd use:
=sum(c2:c65536)

well, for column C.

kelmonster wrote:
>
> 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

--

Dave Peterson

[Bob Phillips]

Probably not good enough, but I'll offer it anyway.

Select a range of cells to put the numbers in. Then just start entering the
numbers, you will see the SUM totting up to the right of the status bar, it
will say SUM=nn

--

HTH

RP
(remove nothere from the email address if mailing direct)


"kelmonster" <[email protected]> wrote in message
news:[email protected]...
> 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

[JR]

In your "=sum()", just make your last number well below where you think you
will stop on the spreadsheet, or just enter 65536 as the last number in your
formula.

"kelmonster" wrote:

> 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

[[email protected]]

kelmonster wrote:
> 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(...)?

Put =SUM(A:A) into B1, for example.

One problem: you will not see B1 after you
enter so many values in column A that row 1
rolls off the top.

[[email protected]]

Bob Phillips wrote:
> Probably not good enough, but I'll offer it anyway.
> Select a range of cells to put the numbers in. Then just start entering the
> numbers, you will see the SUM totting up to the right of the status bar, it
> will say SUM=nn

I suspect this is exactly what the OP wants.
But it does not seem to work for me. When I
highlight column A (by clicking on the "A"
title), I see the sum in the lower right.
But the sum disappears as soon as I click on
a cell to continue entering into the column.
Of course, I can click on the column again.
But that is not exactly the same as "seeing
the SUM tottin up" as I enter values into
column A. Am I doing something wrong?

[Bob Phillips]

You don't then click on a cell.

Just select the cells to input and start typing. Each time you hit Enter, it
moves onto the next cell with all still selected.

--

HTH

RP
(remove nothere from the email address if mailing direct)


<[email protected]> wrote in message
news:[email protected]...
> Bob Phillips wrote:
> > Probably not good enough, but I'll offer it anyway.
> > Select a range of cells to put the numbers in. Then just start entering
the
> > numbers, you will see the SUM totting up to the right of the status bar,
it
> > will say SUM=nn
>
> I suspect this is exactly what the OP wants.
> But it does not seem to work for me. When I
> highlight column A (by clicking on the "A"
> title), I see the sum in the lower right.
> But the sum disappears as soon as I click on
> a cell to continue entering into the column.
> Of course, I can click on the column again.
> But that is not exactly the same as "seeing
> the SUM tottin up" as I enter values into
> column A. Am I doing something wrong?
>

[Earl Kiosterud]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[Roger Govier]

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" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>
>