Lab › Sorting, Filtering & Lists › Filter a Region and Total It

Filter a Region and Total It: Excel Lab

Lab 24 · IntermediateFilterSUBTOTAL

The task: Show only the East region and get the total of the rows you can see.

1 Watch how it is done

1. Step 1: Total that follows the filter

   =SUBTOTAL(9,C4:C13)

   • Click the cell next to Visible Total.
   • Type =SUBTOTAL(9,C4:C13) and press Enter.
   • 9 means SUM, but SUBTOTAL skips rows hidden by a filter.

2. Step 2: Filter Region = East

   • Click any cell inside the table.
   • Press Ctrl + Shift + L (or Data › Filter).
   • Click the arrow on Region, untick Select All, tick East, click OK.
   • The Visible Total now adds only East.

2 Your turn

3 Check your answers

Stuck? Download the solution file and compare it with yours.

Next lab: Monthly Sales Totals →
Want the theory? Read the Sorting, Filtering & Lists lessons →
← More Sorting, Filtering & Lists labs · All lab categories