If you want to sum columns of data automatically so that the totals show only the sum of visible cells (for example), Excel’s Tables features can do it.