Then, click cell D2, which is the data subset whose contribution to the overall total you want to calculate. If you've used a formatted table, this will force Excel to add the column name to your ...

The best new tool from Microsoft Excel is undoubtedly the SCAN function. Here's how to use it to calculate running totals. Find the full guide at Spreadsheet Point.