Your example shows no excluded cells.

For example, sum of A1:A70 + A71:115

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

On Thu, 3 Jan 2008 15:51:37 -0800, "Anthony B" wrote:

"gls858" wrote in message
...
Anthony B wrote:
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

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.