How do I autosum a filtered column
 

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?

How do I autosum a filtered column
 

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

On Feb 18, 12:36*am, Mike Herron <Mike
wrote:
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?