# How to Use a LARGE IF Formula in Google Sheets

You can use the following methods to create a LARGE IF formula in Google Sheets:

Method 1: LARGE IF with One Criteria

```=ArrayFormula(LARGE(IF(A2:A11="value",C2:C11),2))
```

This formula finds the second largest value in column C where the value in column A is equal to “value.”

Method 2: LARGE IF with Multiple Criteria

```=ArrayFormula(LARGE(IF((A2:A11="value1")*(B2:B11="value2")=1,C2:C11),5))
```

This formula finds the fifth largest value in column C where the value in column A is equal to “value1” and the value in column B is equal to “value2.”

The following examples show how to use each method with the following dataset in in Google Sheets: ### Example 1: LARGE IF with One Criteria

We can use the following formula to calculate the second largest value in the Points column only for the rows where the Team column is equal to “Spurs”:

`=ArrayFormula(LARGE(IF(A2:A11="Spurs",C2:C11),2))`

The following screenshot shows how to use this syntax in practice: We can see that the second largest Points value among rows where Team is equal to “Spurs” is 26.

### Example 2: LARGE IF with Multiple Criteria

We can use the following formula to calculate the second largest value in the Points column only for the rows where the Team column is equal to “Spurs” and the Position column is equal to “Guard”:

`=ArrayFormula(LARGE(IF((A2:A11="Spurs")*(B2:B11="Guard")=1,C2:C11),2))`

The following screenshot shows how to use this syntax in practice: We can see that the second largest Points value among rows where Team is equal to “Spurs” and Position is equal to “Guard” is 24.

Note: You can find the complete documentation for the LARGE function in Google Sheets here.