How to Sum visible cells only in Excel

This is a picture blog. Self-explanatory! Learn how to Sum visible cells only using the Aggregate function.

Aggragate function to Sum visible cells only

Works only in vertical direction (not horizontal). It is best to use it with Excel Tables as shown above. That way, adding more data will automatically update the formula results.
Works from Office 2010 onwards.

Share on linkedin
Share on facebook
Share on twitter

Queries | Comments | Suggestions | Wish list

teams logo

Teamwork Beyond Meetings

Thu 5th Nov – 7pm IST 

Teams Gif

Teamwork Beyond Meetings

Event by Dr. Nitin Paranjape
Thursday, 5th Nov
7 pm IST