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?

Instead of having:

=SUM(D4102)

you should change this to:

=SUBTOTAL(9,D4102)

then it will reflect only the visible rows.

Hope this helps.

Pete

On Feb 18, 12:36*am, Mike Herron <Mike
Her...@discussions.microsoft.com> 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?