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