Building a Total Row
Let’s build a row to calculate the total sales for each year. Below the table, Label a row as Total. For starters, let’s use the familiar SUM formula. Underneath the column for each year, type the SUM function and select the range of cells in the table for the corresponding year. Since this is an Excel Data Table now, it will convert that cell range (normally, D3:D28) to it’s Data Table range name. Repeat the process for each year’s column.
The end result will be a total for each year. Looks great! For now…
Get the latest Excel tips and tricks by joining the newsletter!
Andrew Roberts has been solving business problems with Microsoft Excel for over a decade. Excel Tactics is dedicated to helping you master it. You can read more of his writing on his personal blog at NapkinMath.io.
Join the newsletter to stay on top of the latest articles. Sign up and you'll get a free guide with 10 time-saving keyboard shortcuts!