LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #10   Report Post  
Posted to microsoft.public.excel.newusers
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Colume Headings Gu y Excel Worksheet Functions 1 November 30th 07 12:40 PM
3 COLUME CHART BANDIT Excel Worksheet Functions 0 March 21st 06 07:17 PM
How do I calculate my aluminum can pounds for quick reference? ksgaloh Excel Discussion (Misc queries) 1 October 3rd 05 10:19 PM
How can I look up max of one colume and display the colume to the. Brian Cornejo Excel Worksheet Functions 2 February 21st 05 05:47 AM
How do I delete 100 account numbers from a spreadsheet colume wer. Ndubuisi Azuogu Excel Worksheet Functions 2 November 11th 04 04:11 PM


All times are GMT +1. The time now is 07:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"