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 |
Jane | 26 | Los Angeles |
Mike |