Home > DeveloperSection > Articles > Count, Max, Min Function in Excel

Ratings:
0 Comment(s)
4170  View(s)
Rate this:

# COUNT

Excel provided one most important keyword that is COUNT function. COUNT Functions used to count total number of cells in a selected range of data. COUNT function's return total number only those cells that contain numbers. COUNT function ignores empty cells or those contain text. If a number is later added to an empty cell or inserted into new row then function will be automatically updated to include this new data.

## Figure 1:

COUNT function formula

=COUNT (range)

For example calculate total number of sales Person then formula become as below

=COUNT(B4:B9)

Result: 6

See Figure 2.

# COUNTIF

The COUNTIF function combines the IF functions and COUNT function in Excel. This combination return number of times specific data is found in a selected group of cells. The IF portion of the function determines what data meets the specified criteria and the COUNT part does the counting.

COUNTIF function formula

=COUNTIF (range,condition)

For example calculate total number which value greater than \$15000from column “Total” then formula become as below

=COUNTIF(G4:G9,F14)

Result: 3

F14 is a cell index where we have defined condition.

See Figure 2.

# COUNTIFS

Excel's COUNTIFS function can be used to count up the number of data records in a selected range that match specific criteria. COUNTIFS function allowing you to specify from 2 to 127 criteria rather than just one as in COUNTIF.

COUNTIFS function formula

=COUNTIFS (range, range, …..n)

For example calculate total number which value greater than \$5000from “January”, \$6000 from “February” and \$7000 from “March”column then formula become as below

=COUNTIFS(D4:D9,F15,E4:E9,G15,F4:F9,H15)

Result: 1

F15, G15, H15 are a cell index where we have defined formula.

See Figure 2.

# MAX

MAX function will be return maximum numeric value from selected range

MAX function formula

=MAX(Range)

For example I want to find out maximum value from moths column (January, February, March) then formula become as below

=MAX(D4:F9)

Result: \$9,568.00

See Figure 2.

# MIN

MIN function will be return minimum numeric value from selected range

MIN function formula

=MIN(Range)

For example I want to find out minimum value from moths column (January, February, March) then formula become as below

=MIN(D4:F9)

Result: \$1,205.00

See Figure 2.