ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   SUM OF COLUMN A5-A50 IN EXCEL? (https://www.excelbanter.com/excel-worksheet-functions/133232-sum-column-a5-a50-excel.html)

bobby b385[_2_]

SUM OF COLUMN A5-A50 IN EXCEL?
 
this is an expense report for 2006.There are 10 to 50 figures in a given column
ie. A that I need a sum of the total column

KL

SUM OF COLUMN A5-A50 IN EXCEL?
 
=SUM(A5:A50)
???

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/pr...A-9E6C73C09A36


"bobby b385" <bobby wrote in message ...
this is an expense report for 2006.There are 10 to 50 figures in a given column
ie. A that I need a sum of the total column


Bob Phillips

SUM OF COLUMN A5-A50 IN EXCEL?
 
=SUM(A:A)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"bobby b385" <bobby wrote in message
...
this is an expense report for 2006.There are 10 to 50 figures in a given
column
ie. A that I need a sum of the total column





All times are GMT +1. The time now is 04:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com