Autopilter

  • Thread starter Thread starter charli
  • Start date Start date
C

charli

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.
 
Hi,

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

Mike
 
Back
Top