How To Use MAX Function in Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to use the MAX function in Google Sheets.

How To Use MAX Function in Google Sheets

The MAX function in Google Sheets is a useful tool if you want to quickly find the largest value in a given dataset.

Users can either provide several values as arguments to the MAX function or provide one or more cell ranges as arguments.

For example, suppose you have an order dataset with an amount field that indicates how much an order costs. You can use the MAX function to find the largest single-purchase order in your database.

In this guide, we’ll explain how to use the MAX function in Google Sheets, and show you a few examples of the function in action.

How To Find the Maximum Value in a Range in Google Sheets

Here’s how to use the MAX function to find the largest or maximum value in a given range in Google Sheets.

Step 1

First, select a blank cell to place the maximum value.

In this example, we want to find the largest value in the range A2:A16 and output this value in cell D1.

Step 2

Type the formula “=MAX(“ to start the MAX function in Google Sheets.

Step 3

Add the cell range you want to search as the sole argument of the MAX function.

Step 4

Hit the Enter key to evaluate the MAX function.

In this example, we’ve determined that the largest value in column A is 8760.

Step 5

You may also provide several ranges to the MAX function.

In the example above, we want to find the largest value found in either column A or C.

Summary

This guide should be everything you need to to start using the MAX function in a Google Sheets spreadsheet.

You may make a copy of this example spreadsheet to test it out on your own.