Sum in Autofilter

A

Alex

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
 
R

Richard Buttrey

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
Click to expand...


Re 1.
=Sum(G3:G65536)

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

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top