---
title: "Count, Max, Min Function in Excel"  
description: "Count, Max, Min Function in Excel"  
author: "AVADHESH PATEL"  
published: 2013-02-28  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1155/count-max-min-function-in-excel  
category: "excel"  
tags: ["excel"]  
reading_time: 2 minutes  

---

# Count, Max, Min Function in Excel

[COUNT](https://www.mindstick.com/forum/2295/how-to-count-number-of-visitors-for-website)

[Excel](https://www.mindstick.com/articles/157133/tips-to-learn-excel-the-basics) provided one most important [keyword](https://yourviews.mindstick.com/view/87345/explained-the-importance-of-keyword-traffic) that is COUNT [function](https://www.mindstick.com/articles/43970/purchase-suitable-wedding-dresses-for-your-wedding-function). COUNT [Functions](https://www.mindstick.com/forum/34086/jquery-callback-functions) used to count total number of cells in a selected [range](https://yourviews.mindstick.com/view/87860/does-biden-wants-nuclear-war-provokes-russia-by-long-range-missiles) of [data](https://www.mindstick.com/articles/326933/5-reasons-big-data-is-important-to-the-logistics-industry). 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](https://yourviews.mindstick.com/view/83455/pm-modi-s-uae-visit-after-prophet-row) then function will be automatically updated to include this new data.

##### Figure 1:

![Count, Max, Min Function in Excel](https://www.mindstick.com/mindstickarticle/8d87491b-4403-4735-ab45-31d3e059e00c/images/382fa478-bf2a-476f-b3a4-7b67790f7568.png)

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](https://www.mindstick.com/mindstickarticle/8d87491b-4403-4735-ab45-31d3e059e00c/images/bafe7563-f163-4264-a41b-93027e8cc945.png)

\

---

Original Source: https://www.mindstick.com/articles/1155/count-max-min-function-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.