If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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 | |
Display Modes | |
|
|