Excel's AGGREGATE function lets you ... showing in the table after you apply filters. To calculate the overall total, in cell C1, type: =SUM(Player_Goals[Goals scored]) Now, even after you apply ...