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

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


ok, I found it. Its in the bottom right corner,
showing sum, average and count.

Actually I was talking about the icon in the editing box on the home
tab. It will insert the sum formula for that column after the last entry
in the column.

gls858