Excel Formulas to Rank Items with One or more Criteria!!
Tags: excelformula, excelformulas
Published: 2021-04-21 07:36:18

---
title: Excel Formulas to Rank Items with One or more Criteria!!
published: true
date: 2021-04-12 04:41:50 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-rank-items-with-one-or-more-criteria/
---

Excel has a [**RANK function**](https://geekexcel.com/how-to-use-excel-rank-function-in-office-365-with-examples/), so you can calculate where each number stands in a list of numbers. In this tutorial, we will discuss the simple formula to **rank the items in a list using one or more criteria in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formula to rank list of items](https://geekexcel.com/wp-content/uploads/2021/04/Formula-to-rank-list-of-items.png)](https://geekexcel.com/excel-formulas-to-rank-items-with-one-or-more-criteria/formula-to-rank-list-of-items/#main)<figcaption id="caption-attachment-22895">Formula to rank list of items</figcaption>

## General Formula:

- You can use the below formula to rank the items.

**=[COUNTIFS](https://geekexcel.com/excel-formulas-to-count-numbers-by-range-with-countifs-function/)(criteria\_range,criteria,values,”>”&value)+1**

## Syntax Explanations:

- **COUNTIFS** – The Excel **COUNTIFS Function** will help count the number of cells that meet multiple criteria or conditions.
- **Criteria\_range** – It specifies the criteria range.
- **Values** – It represents the input values from your worksheet.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

Let’s consider the below example image.

- First, we will enter the input values in **Column B** to **Column D**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-11.png)<figcaption id="caption-attachment-22896">Input Ranges</figcaption>

- Then, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/04/Enter-the-formula-1.png)<figcaption id="caption-attachment-22898">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell as shown in the below image.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result-11.png)<figcaption id="caption-attachment-22897">Result</figcaption>

## Wrap-Up:

Here we have described the simple formula to **rank the items in a list using one or more criteria in Excel from this tutorial**. Hope you like this article. Please share your **query** below in the **comment** box. We will assist you. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Excel Formulas to Highlight Target Percentage with Conditional Formatting](https://geekexcel.com/excel-formulas-to-highlight-target-percentage-with-conditional-formatting/)**
- **[Excel Formulas to Highlight the Integer Values Only ~ A Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-highlight-the-integer-values-only/)**
- **[Formulas to Highlight Intersecting Rows and Columns Exact Match!!](https://geekexcel.com/excel-formulas-to-highlight-intersecting-rows-and-columns-exact-match/)**
- **[Excel Formulas to Highlight the Multiples of Specific Value ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-highlight-multiples-of-specific-value/)**