# Count the Occurrences of the Largest or Smallest Value in a Range

Author:

How to count the occurrence of the largest or smallest value in a range; basically, how many times the MAX or MIN value occurs in a range.

Max

Min

Notes

## Max

``````=COUNTIF(A1:A6,MAX(A1:A6))
``````

A1:A6 is the range with the values. Change that in both places in the formula to fit your data. Result: The MAX() function gets the highest value from the range and then returns that to the COUNTIF() function, which uses that to determine which values in the range to count.

## Min

``````=COUNTIF(A1:A6,MIN(A1:A6))
``````

A1:A6 is the range with the values. Change that in both places in the formula to fit your data. Result: The MIN() function gets the lowest value from the range and then returns that to the COUNTIF() function, which uses that to determine which values in the range to count.

## Question? Ask it in our Excel Forum

Excel Function: COUNTIF(), MAX(), MIN()

Similar Content on TeachExcel
test 1
: Code: Sub Convert_Html_Entities() ''''''''''''''  TeachExcel.com  '''''''''''''' 'Conver...
test 2 ? 国
: Sub Convert_Html_Entities() ''''''''''''''  TeachExcel.com  '''''''''''''' 'Convert HTML...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Macro to Replace HTML Entities with Readable Text
: Excel macro that converts all HTML entities into their readable equivalent. This includes ...
Get the Name of a Worksheet in Macros VBA in Excel
Tutorial: How to get the name of a worksheet in Excel using VBA and Macros and also how to store tha...
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Tutorial Details
Excel Function: COUNTIF(), MAX(), MIN()