Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Use Autosum and Max or Min to calculate the largest or smallest value in a range. For example, you can use it to find out who has the the smallest error rate in a production run at a factory or the largest salary in the department. 

If the cells are in a contiguous row or column

  1. Select a cell below or to the right of the numbers for which you want to find the smallest number.

  2. On the Home tab, select the arrow next to Excel AutoSum Sigma button icon 13px AutoSum in the Editing group.

  3. Select Min (calculates the smallest) or Max (calculates the largest), and then press ENTER.

If the cells are not in a contiguous row or column

To do this task, use the MIN, MAX, LARGE function, or LARGE functions, rather than Excel AutoSum Sigma button icon 13px Autosum.

Example

Copy the following Data column to a blank worksheet to column A. 

1

Data

2

10

3

7

4

9

5

27

6

0

7

4

Copy these formulas to the spreadsheet to show an example.

Formula

Description (Result)

=MIN(A2:A7)

Smallest number in the range (0)

=MAX(A2:A7)

Largest number in the range (27)

=SMALL(A2:A7, 2)

Second smallest number in the range (4)

=LARGE(A2:A7,3)

Third largest number in the range (9)

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

LARGE

MAX

MIN

SMALL

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×