Lesson 41: Some more Functions (1)

“Min” / “Max”

The “Min” and “Max” functions are used frequently. We use them to display the maximum or the minimum number from a “Range” of values.

Choose the tab “Home” or “Formulas” 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” allows you to choose a “Range” for which the maximum or minimum number has to be displayed.
Click Enter when you are satisfied with what Excel suggests or click and drag the blue edge of the range if you want the range to change.

This was easy…. Let’s go to the next one….

“Average”

We use the “Average” function to find the average of values from a “Range” of cells. The principles are the same as with 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 Number functions

In general, a formula which uses the “COUNT” function returns the number of cells available in a “Range”. The COUNT function may or may not comply with one or more conditions.

Below is some more information about different COUNT possibilities:

Function Example

COUNT NUMBERS = COUNT (F1: F100)

counts the number of cells in a “Range” with numeric values

COUNTBLANK = COUNTBLANK (E1: E100)

counts the number of empty cells in a “Range”

COUNTA = COUNTIF (E1: E100)

counts the number of non-empty cells in a “Range”

COUNTIF = COUNTIF (C1: C13, “> 1000”)

counts the number of cells in a “Range” associated with a particular condition

COUNTIFS = COUNTIFS (E4:E8,”> 4000″,A4:A8,”= Coffee”)

Counts the number of cells in a “Range” that meet multiple criteria or conditions. In below example, the value in column E should be greater than 4000, and the value in column A should be “coffee”.

Awesome!
You've completed Lesson 41 START NEXT LESSON

Lesson 41

Office 2010 - Excel