Explanation

Consolidate is not limited to Sum.

You can use:

Count

Counts the number of records.

Average

Calculates the average value.

Max

Returns the highest value.

Min

Returns the lowest value.

Example

Branch	Sales
Sirsa	25500
Hisar	17000
Fatehabad	24000

Average:

=(25500+17000+24000)/3

Result: ₹22,166.67

Practice

Using branch sales data, create:

• Total Sales
• Average Sales
• Maximum Sales
• Minimum Sales