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

Count, Max, Min Function in Excel


Excel Excel 
Ratings:
0 Comment(s)
 3592  View(s)
Rate this:

Count, Max, Min Function in Excel

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, Max, Min Function in Excel

 

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.

Figure 2:

Count, Max, Min Function in Excel


Don't want to miss updates? Please click the below button!

Follow MindStick