Column sum into specific cell

's Computer Specifications

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

's Computer Specifications

=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

's Computer Specifications

=SUM(G:G) entered in E2

Gord Dibben MS Excel MVP

On Sun, 27 May 2007 12:02:00 -0700, ewshort <(E-Mail Removed)>
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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro from cell specific to whole column	Bean Counter	Microsoft Excel Misc	4	27th May 2010 11:04 PM
lookup specific value in a column and show it in a new cell	Piotr (Peter)	Microsoft Excel Worksheet Functions	3	5th Sep 2008 09:02 AM
first cell in a column with a specific value	=?Utf-8?B?bXBpZXJyZQ==?=	Microsoft Excel Worksheet Functions	3	10th Dec 2006 08:09 PM
search column for specific cell using vba	=?Utf-8?B?ZGF2ZTkx?=	Microsoft Excel Programming	1	30th Jul 2005 05:59 PM
Find last cell in a specific column	Eva Shanley	Microsoft Excel Programming	2	8th Sep 2004 09:01 PM