Every month I import a file into excel and I set it up with auto filter. I would like to add a field that will only sum the fields filtered not every field in between. Basically as a person filters this field will automatically adgust to only sum the records showing. Can someone show me how to set this up?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
adding totals in Excel 1
- Thread starter Buddha1
- Start date
-
1
- #2
SkipVought
Programmer
Hi,
Use the SUBTOTAL(9,range) function. THis sums only VISIBLE cells.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Use the SUBTOTAL(9,range) function. THis sums only VISIBLE cells.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Status