A common question I get asked when I’m teaching people how to filter data is “how do I sum only the visible rows when filtering data in Excel”?
It’s very common for people to try creating a SUM total at the bottom of a list and then filter the data hoping that the total will change to reflect the SUM of the data displayed. However, the total doesn’t update. It still shows the SUM of the entire list.
You can definitely use the AutoSum button to instantly create a total that will update as you filter your data. Here’s how you do it.Continue Reading