ExcelBanter - How can i get a sum of the data filtered in a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can i get a sum of the data filtered in a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/225614-how-can-i-get-sum-data-filtered-pivot-table.html)

tarabull

How can i get a sum of the data filtered in a pivot table

Is there any way to automatically update a sum based on the data showing when
filtered?

Luke M

How can i get a sum of the data filtered in a pivot table

To only sum visible data:
=SUBTOTAL(9,A2:A100)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

"tarabull" wrote:

Is there any way to automatically update a sum based on the data showing when
filtered?

All times are GMT +1. The time now is 07:32 AM.