A
Anthony B
How to quick calculate sum of colume A1 to A115?
Or, do I always have to set up formular =sum(A1:A15) to get the sum?
Or, do I always have to set up formular =sum(A1:A15) to get the sum?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
=SUM(A2:OFFSET(A2,MATCH(999999,A:A,1),1))
D
Dr Teeth
=SUM(A2:OFFSET(A2,MATCH(999999,A:A,1),1))
Can you explain how that works? That way this newuser would be able to
learn how the command works and not have to ask again for a different
range.
Cheers,
Guy
** Stress - the condition brought about by having to
** resist the temptation to beat the living daylights
** out of someone who richly deserves it.
T
TRYING
Anthony B:
Another approach would be to define a name for your range, for example
QuickSum. After you do this, the named range would be available in the Name
Box (which is immediately above column A. When you select that named range,
you should see the sum of selected cells in your status bar (the very bottom
of the spreadsheet). I use 2007 and by right-clicking this status bar, the
Customize Status Bar window appears and mine shows that Average, Count, and
Sum are checked. Whenever I select a range, the status bar automatically
shows Average, Count, and Sum.
Of course, if you type that formula =sum(A1:A15) in a convenient cell, say
B1, you only have to do it once and the sum will be there. Therefore you
don't have to " ALWAYS have to set up formula =sum(A1:A15) to get the sum" as
long as you save the worksheet.
Another approach would be to define a name for your range, for example
QuickSum. After you do this, the named range would be available in the Name
Box (which is immediately above column A. When you select that named range,
you should see the sum of selected cells in your status bar (the very bottom
of the spreadsheet). I use 2007 and by right-clicking this status bar, the
Customize Status Bar window appears and mine shows that Average, Count, and
Sum are checked. Whenever I select a range, the status bar automatically
shows Average, Count, and Sum.
Of course, if you type that formula =sum(A1:A15) in a convenient cell, say
B1, you only have to do it once and the sum will be there. Therefore you
don't have to " ALWAYS have to set up formula =sum(A1:A15) to get the sum" as
long as you save the worksheet.
G
Gord Dibben
In Namebox type A1:A115 then hit Enter.
Right-click on status bar and "Sum"
Gord Dibben MS Excel MVP
Right-click on status bar and "Sum"
Gord Dibben MS Excel MVP
M
MartinW
A couple of other ways.
1
To sum A1:A115
In A116 press Alt and = together
let go then hit enter
2
Highlight A1:A115
And look at the status bar at the bottom right of your screen
You may have to right click on the status bar and check sum first.
HTH
Martin
1
To sum A1:A115
In A116 press Alt and = together
let go then hit enter
2
Highlight A1:A115
And look at the status bar at the bottom right of your screen
You may have to right click on the status bar and check sum first.
HTH
Martin
D
Don Guillett
It is self adjusting using match to find any number greater than possible in
your column. As you add/delete rows it will adjust the sum accordingly.
your column. As you add/delete rows it will adjust the sum accordingly.
D
Dr Teeth
It is self adjusting using match to find any number greater than possible in
your column. As you add/delete rows it will adjust the sum accordingly.
Cheers Don, much appreciated.
Cheers,
Guy
** Stress - the condition brought about by having to
** resist the temptation to beat the living daylights
** out of someone who richly deserves it.
G
gls858
Anthony said:How to quick calculate sum of colume A1 to A115?
Or, do I always have to set up formular =sum(A1:A15) to get the sum?
I see you have several suggestions but for me the quickest is select
A1 then move your cursor to the bottom of the cell and you will get a
symbol with 4 points, hold the shift key and double click. This will
highlight A1 through A115 then hit the sum icon. It's the symbol that
looks kind of link an E(sigma sign).
gls858
A
Anthony B
gls858 said:I see you have several suggestions but for me the quickest is select
A1 then move your cursor to the bottom of the cell and you will get a
symbol with 4 points, hold the shift key and double click. This will
highlight A1 through A115 then hit the sum icon. It's the symbol that
looks kind of link an E(sigma sign).
gls858
I am using Excel 2007 of the Microsoft Office 2007.
Where is the sum icon?
Is there anyway I can exclude a few cells in this entire column?
For example, sum of A1:A70 + A71:115.
A
Anthony B
">>
ok, I found it. Its in the bottom right corner,
showing sum, average and count.
I am using Excel 2007 of the Microsoft Office 2007.
Where is the sum icon?
Is there anyway I can exclude a few cells in this entire column?
For example, sum of A1:A70 + A71:115.
ok, I found it. Its in the bottom right corner,
showing sum, average and count.
G
Gord Dibben
Your example shows no excluded cells.
which is the same as A1:A115
If you meant A1:A70 + A75:A115 yoi will have to use CTRL + Click and drag to
select the two distinct ranges then look on the status bar.
Gord Dibben MS Excel MVP
which is the same as A1:A115
If you meant A1:A70 + A75:A115 yoi will have to use CTRL + Click and drag to
select the two distinct ranges then look on the status bar.
Gord Dibben MS Excel MVP
G
gls858
Actually I was talking about the icon in the editing box on the homeAnthony said:">>
ok, I found it. Its in the bottom right corner,
showing sum, average and count.
tab. It will insert the sum formula for that column after the last entry
in the column.
gls858