The original data is formatted as a Table object, so you might think you can reference those columns using #. Let’s try that and see what happens. Enter =C3# to return the items in the Value column.

In this Excel tutorial, I’ll show you how to run subtotals on a simple data set and then quickly apply formatting that will make those totals really stand out. SEE: Software Installation Policy ...