Explanation

Subtotal can perform different calculations.

Available Functions

Function	Purpose
SUM	Total values
COUNT	Count numeric values
AVERAGE	Average value
MAX	Highest value
MIN	Lowest value
PRODUCT	Product of values

Example

For Sirsa sales:

₹4,000, ₹25,500, ₹12,000

Sum:

₹41,500

Average:

₹13,833.33

Maximum:

₹25,500

Minimum:

₹4,000

Practice

Create separate reports using:

• Sum
• Count
• Average
• Maximum
• Minimum