Question

Define the following with the help of an example:

a) Subtotals​

Answer 1

Explanation:

SUBTOTAL Function.

Use the SUBTOTAL function to exclude filtered or hidden rows when calculating a total. You can choose any one of the 11 functions that SUBTOTAL can calculate, such as Sum, Average, Count or Max.

This video show how to use SUBTOTAL or the newer AGGREGATE function, to work with filtered data.

Answer 2

Answer:

SUBTOTAL: This is the total price for each product in your order or the total price found for a selected delivery window in your order. If you also have a discount applied to a product, then you will find the updated discount price total for that particular item or delivery window in your order.

Example: When you subtotal a horizontal range using a function_num of 101 or greater, such as SUBTOTAL(109,B2:G2), hiding a column does not affect the subtotal.