Ravindra BagaleCourses & study guides

6. Tables, Sorting and Filtering

6.3 The Total Row

By Last updated:

Steps in Excel

  1. Click inside the Table › Table Design › Table Style Options › Total Row (or Ctrl + Shift + T).
  2. A Total row appears at the bottom. Click a cell in it › pick Sum, Average, Count, Max, Min, StdDev… from the drop-down.
  3. Excel writes =SUBTOTAL(109,[Amount]) – 109 means SUM of visible rows.
  4. Filter the Table to Pune – the Total Row now shows Pune's total only.

Worked example. Salman turns on the Total Row: Amount → Sum (₹2,870 on the mini dataset), Delivery Mins → Average (12.8), Order ID → Count (10). After filtering City = Pune: ₹544, 11 mins, 4 orders.

Ravindra Bagale's Tip

Total Row cha total filter pramane badalto – khup students filter lavlela visartat aani "total kami ka?" mhanun ghabartat. Report pathvaychya aadhi filter icons bagha. Ani Table chya khali swatah =SUM() lihu naka – Total Row vapra, to Table sobat khali sarakto.

Practice task

Turn on the Total Row for tblOrders with Sum of Amount, Average of Delivery Mins and Count of Order ID. Filter to each platform and note the totals.