Autopilter

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.
 
M

Mike H

Hi,

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to figure the formula 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Macro Help 6
Excel not responding before calculations 1
Copy rows to new sheet based on value in column A 0
Macro help?: move row to other sheet when text is entered in cell 0
Sorting in a protected cell (Excel 2007) 0
autofilter 4

Top