RANK + IF (conditional rank) Function in Excel: Syntax, Examples and Free Practice
RANK + IF (conditional rank) is an Excel Statistical function. A workaround using SUMPRODUCT to rank a value only among rows that meet a certain condition, since RANK alone can't filter.
RANK + IF (conditional rank) syntax
Arguments
criteria_range: Range to testcriteria: Value to matchvalue_range: Range of valuesthis_value: The value being ranked
When to use RANK + IF (conditional rank)
Ranking a salesperson's performance only among their own team, not the whole company.
Practice RANK + IF (conditional rank) online, free
Open the live Excel-style spreadsheet and try RANK + IF (conditional rank) yourself. No Excel install or sign-up needed to start.
Practice RANK + IF (conditional rank) now →More Statistical functions
Frequently asked questions
What does the RANK + IF (conditional rank) function do in Excel?
A workaround using SUMPRODUCT to rank a value only among rows that meet a certain condition, since RANK alone can't filter.
What is the syntax of RANK + IF (conditional rank) in Excel?
The syntax is =SUMPRODUCT((criteria_range=criteria)*(value_range>this_value))+1. criteria_range: Range to test; criteria: Value to match; value_range: Range of values; this_value: The value being ranked.
Where can I practice RANK + IF (conditional rank) online for free?
Open the free live spreadsheet on Cellgrids and try RANK + IF (conditional rank) yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts