Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum from top
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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" 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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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. |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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 Hi kel Try Sum(A2:A65536) -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=399454 |
#8
|
|||
|
|||
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) wrote in message oups.com... 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? |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|