Sum in Autofilter
 

Hi
New to Excel 2000 i have a worksheet in which i have 1500 rows of data.

In Row 2 I want to add a function which will give me the sum of column G
irrespective of how many additional rows are added - i cant seem to get the
syntax right. Can someone help me please
Also
If I then add an autofilter to filter based on data in another column, I
need to the sum above to relefect the sum of the filtered records. is this
possible please?

thanks

Sum in Autofilter
 

On Mon, 18 Sep 2006 10:08:46 +0100, "Alex"
wrote:

Hi
New to Excel 2000 i have a worksheet in which i have 1500 rows of data.

In Row 2 I want to add a function which will give me the sum of column G
irrespective of how many additional rows are added - i cant seem to get the
syntax right. Can someone help me please
Also
If I then add an autofilter to filter based on data in another column, I
need to the sum above to relefect the sum of the filtered records. is this
possible please?

thanks



Re 1.
=Sum(G3:G65536)

Re 2.
=SubTotal(9,G3:G65536)

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________