ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I want to add up the result of a filtered list (https://www.excelbanter.com/excel-worksheet-functions/134343-i-want-add-up-result-filtered-list.html)

scott

I want to add up the result of a filtered list
 
I have a large list of data spanning several months. I want to be able to
filter the list and have a row that totals all the entries below each day.
Surely there is an easy way to auto sum the reults of a filtered list?

Ron de Bruin

I want to add up the result of a filtered list
 
Look at the Subtotal function Scott

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Scott" wrote in message ...
I have a large list of data spanning several months. I want to be able to
filter the list and have a row that totals all the entries below each day.
Surely there is an easy way to auto sum the reults of a filtered list?



All times are GMT +1. The time now is 01:32 PM.

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