Microsoft Office Tutorials and References

In Depth Information

**Computing Statistics**

NETWORKDAYS

The
NETWORKDAYS
function returns the number of working days between two dates. Excludes

weekends and specified holidays.

The
NETWORKDAYS
function allows you to find out the total number of working days between

two dates excluding the weekends and holidays. This is an extremely important function

when calculating schedules that have to be completed within specific time frames. Notice the

structure of the example in Figure 2.2. The date value operates as text in quotes.

Figure 2.2

Common
DATE AND

TIME
functions.

Computing Statistics

AVERAGE

AVERAGE
returns the average of the arguments.

The
AVERAGE
function averages the numbers over a range or in the form of an array over several

ranges. Figure 2.3 shows the
AVERAGE
function averaging the dollars from column E, “Total

Dollars.”

COUNTA

Use
COUNTA
to count the number of cells that are not empty and the values within the list of

arguments.

The
COUNTA
function illustrated in Figure 2.3 shows the count over the range of cells to equal 5.

Blank cells are not counted. (Use the
COUNT
function if you want to count blank cells as well.)

COUNTIF

The
COUNTIF
function counts the number of cells within a range that meets the given criteria.

COUNTIF
is used over a range of cells and returns a numeric result based on logical criteria. The

logical criteria in Figure 2.3 is in quotes, and counts all values in excess or greater than 10,000.