ExcelBanter - Autopilter

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

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

- - Autopilter (https://www.excelbanter.com/excel-discussion-misc-queries/246082-autopilter.html)

charli

Autopilter

How do i get the sum of a exel sheet that is filterd by autofilter. I only
want to calculate the valuse that i see on the display, but SUM calculatse
every value from the list even when i am using autofilter.

Mike H

Autopilter

Hi,

look in help for SUBTOTAL and you will see how to some visible rows in a
filtered range.

Mike

"charli" wrote:

How do i get the sum of a exel sheet that is filterd by autofilter. I only
want to calculate the valuse that i see on the display, but SUM calculatse
every value from the list even when i am using autofilter.

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