ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Totals In Filters (https://www.excelbanter.com/excel-discussion-misc-queries/117354-totals-filters.html)

Ty Archer

Totals In Filters
 
Hi, can anyone tell me how to perform a sum total on a filter. Everytime I
filter infomration my totals are not of just the filter, it's for everyting
(including items not filtered). I just need to perform a total of the
filtered items only.

Thanks very much

Don Guillett

Totals In Filters
 
look in the help index for SUBTOTAL

--
Don Guillett
SalesAid Software

"Ty Archer" wrote in message
...
Hi, can anyone tell me how to perform a sum total on a filter. Everytime I
filter infomration my totals are not of just the filter, it's for
everyting
(including items not filtered). I just need to perform a total of the
filtered items only.

Thanks very much





All times are GMT +1. The time now is 09:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com