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
Share on pinterest
Share on email

Comments? Suggestions? Wish list?