ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Column sum into specific cell (https://www.excelbanter.com/excel-programming/390218-column-sum-into-specific-cell.html)

ewshort

Column sum into specific cell
 
I'm trying to sum all values in column G, and display result in cell E2. The
length of column G well vary.

I'm a newbie, so thanks in advance for any help.

Wayne

excelent

Column sum into specific cell
 
=sum(g:g)


"ewshort" skrev:

I'm trying to sum all values in column G, and display result in cell E2. The
length of column G well vary.

I'm a newbie, so thanks in advance for any help.

Wayne


Gord Dibben

Column sum into specific cell
 

=SUM(G:G) entered in E2


Gord Dibben MS Excel MVP

On Sun, 27 May 2007 12:02:00 -0700, ewshort
wrote:

I'm trying to sum all values in column G, and display result in cell E2. The
length of column G well vary.

I'm a newbie, so thanks in advance for any help.

Wayne



ewshort

Column sum into specific cell
 
Thank you!

"excelent" wrote:

=sum(g:g)


"ewshort" skrev:

I'm trying to sum all values in column G, and display result in cell E2. The
length of column G well vary.

I'm a newbie, so thanks in advance for any help.

Wayne



All times are GMT +1. The time now is 10:55 PM.

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