View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Anthony B Anthony B is offline
external usenet poster
 
Posts: 3
Default how to quick calculate sum of colume A1 to A115?

"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.