“Min/ Max”

“Min” and “Max” are frequently used functions.
We use them to display maximum or minimum numbers from a range.
Choose the “Formulas” tab in the “Ribbon”.
Select an empty cell where you want to insert the function.

Click the downward pointing arrow next to “Auto sum”, and choose “Min” or “Max”.

Excel suggests a range for which the maximum or minimum number is to be displayed.
Click Enter if you are satisfied with this, click and drag the blue edge of the marquee if you want to change the range.

We have one more function used very frequently.

“Average”

We use the “Average” to find the average of our range.
The process is same as the previous functions, select a blank cell, click the downward pointing arrow next to “Auto sum” and select “Average” from the drop-down menu.

The different functions “Count”

In general, “COUNT” gives the number of cells in a range, which may or may not comply with one or more conditions.
Below, I give some more functions with the different possibilities:

Function                                                             Example
COUNT                                                               = COUNT (F1: F100)
indicates the number of cells in a range with a numeric value

COUNTBLANK                                                  = COUNTBLANK (E1: E100)
indicates the number of empty cells in a Range

COUNTA                                                              = COUNTA (E1: E100)
indicates the number of non-empty cells in a Range

COUNTIF                                                              = COUNTIF (C1: C13, “> 1000”)
indicates the number of cells in a range that satisfy the given condition

COUNTIF                                                                   = COUNTIF (E2: E13, “Oostende” F2: F13, “WV”)
indicates the number of cells in the range with the above conditions.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats