Subtotals are calculated with a summary function, such as Sum or Average, by using the SUBTOTAL function….