Share via

Adding cells that don't include filtered data

Anonymous
2023-05-18T13:59:51+00:00

I have a worksheet and have filtered several entries from various rows. When I try to add the remaining figures up by using autosum, it still adds the figures from the cells i have filtered away. How do I ask it to just add the visible cells? I'm sure I've done this before but can't remember...

TIA, Louise

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-05-18T14:18:50+00:00

    Use the SUBTOTAL function.

    =SUBTOTAL(109, D2:D50)

    will add only the visible cells in D2:D50.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-05-18T15:16:31+00:00

    Thank you so much. I thought there was a different way but can’t think of it

    Thanks again, Louise

    0 comments