Excel Guides

Summing Only Visible Values in Excel

To sum only visible values in Excel, you can use the SUBTOTAL function. This function automatically ignores hidden rows and columns, so it's perfect for use in a scenario like this. For example, say you have a list of data that looks like this:

Name Age City
John 21 New York