How do I autosum a filtered column

M

Mike Herron

Column D on my worksheet has an autosum function for rows 4 to 102. When I
apply a data filter to another column this removes approximately 50 rows but
the sum remains the same; is there anyway I can get it to just sum the data
that has been filtered?
 
P

Pete_UK

Instead of having:

=SUM(D4:D102)

you should change this to:

=SUBTOTAL(9,D4:D102)

then it will reflect only the visible rows.

Hope this helps.

Pete
 

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

Top