| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter using the contents of a particular cell | Excel Discussion (Misc queries) | |||
| Applying an AutoFilter to a string | Excel Discussion (Misc queries) | |||
| How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
| Autofilter not working correctly... | Excel Discussion (Misc queries) | |||
| Strange Results with Autofilter | Excel Discussion (Misc queries) | |||
Threaded Mode
