6. Tables, Sorting and Filtering
6.3 The Total Row
Steps in Excel
- Click inside the Table › Table Design › Table Style Options › Total Row (or Ctrl + Shift + T).
- A Total row appears at the bottom. Click a cell in it › pick Sum, Average, Count, Max, Min, StdDev… from the drop-down.
- Excel writes
=SUBTOTAL(109,[Amount])– 109 means SUM of visible rows. - 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
The Total Row total changes with the filter – many students forget a filter is on and panic: "why is the total lower?" Check the filter icons before sending a report. And don't write your own =SUM() below the Table – use the Total Row; it moves down with the Table.
Ravindra Bagale's Tip – मराठी
Total Row चा total filter प्रमाणे बदलतो – बरेच students filter लावलेला विसरतात आणि "total कमी का?" म्हणून घाबरतात. Report पाठवण्याआधी filter icons बघा. आणि Table च्या खाली स्वतः =SUM() लिहू नका – Total Row वापरा, तो Table सोबत खाली सरकतो.
Ravindra Bagale's Tip – हिंदी
Total Row का total filter के हिसाब से बदलता है – बहुत से students भूल जाते हैं कि filter लगा है और घबरा जाते हैं "total कम क्यों?". Report भेजने से पहले filter icons देखो. और Table के नीचे खुद =SUM() मत लिखो – Total Row इस्तेमाल करो, वह Table के साथ नीचे खिसकती है.
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.