Questions : Teacher want to put the total of the marks in a list of all students in the school. He want to use the filter to get the data of class; section and subjects.
Solutions : Use the '=SUBTOTAL(9,E8:E61)' to get the desired result.
Step 1: Open the list of values
Step 2: Select all the data and apply the auto filter function. Short cut Alt D, F, F.
Step 3: Goto the last cell of the column where the marks ends.
Step 4: In the next row use the Auto sum function. Short cut 'Alt =' and press enter key.
Step 5: Excel will build the subtotal function since the filter is applied in the data.
Step 6: Change the reference series in the function as required to calculate the sum of marks in the visible cells.
Solutions : Use the '=SUBTOTAL(9,E8:E61)' to get the desired result.
Step 1: Open the list of values
Step 2: Select all the data and apply the auto filter function. Short cut Alt D, F, F.
Step 3: Goto the last cell of the column where the marks ends.
Step 4: In the next row use the Auto sum function. Short cut 'Alt =' and press enter key.
Step 5: Excel will build the subtotal function since the filter is applied in the data.
Step 6: Change the reference series in the function as required to calculate the sum of marks in the visible cells.
No comments:
Post a Comment