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 |
