How to use the Formulas of Sum, Max, Min, Average and Count

For Soft Exercise File Click Download Button 

How to use the Formulas of Sum, Max, Min, Average, and Count

SUM:

The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three.

For example:

=SUM(B2:B6) Adds the values in cells B2:B6

=SUM(D2:D6,F2:F6) Adds the values in cells D2:D6, as well as cells F2:F6

Max:

Returns the smallest number is a set of values, ignores logical values and text.

=Max(B2:B6)  Largest value in the cell range B2:B6 is 67

Min:

Returns the smallest number is a set of values, ignores logical values and text.

=Max(B12:A16) 

The largest value in the cell range B12:B16 is 33

Count: 
Count the number of cells in a range that contains numbers.

=Count(B2:B6) 

The function return in B6:B6 is 5

Average:

Returns the average arithmetic mean of its arguments, which can be numbers or names, arrays, or references that contain numbers.