Page 165 - IT 402 v2.0 class 10
P. 165
Step 3: In the roup by box select the column for which subtotal is re uired. If the contents of the selected
column change the subtotals are automatically recalculated.
Step 4: In the alculate subtotals for box select the columns containing the values to obtain a subtotal.
Step 5: In se function box select the desired function to calculate the subtotals. ere we have used
‘Count’ function.)
Step 6: lick on the O button.
e can add another grouping group in same worksheet. For example if we add colour and cost to the
worksheet we can make another group showing sum of cost of erseys colour-wise for each si e.
First group finds the count of si es available and second group displays cost of each colour for the different
ersey si es available.
Advanced Features of Spreadsheet 163

