Excel Magic Trick 810: RANKIF Function RANK IF: Ranking With Conditions - YouTube

Download file: https://people.highline.edu/mgirvin/E... 1. There is no such thing as RANKIF Function, but you can use SUMPRODUCT to RANK with Conditions or Criteria 2. See how to rank studnt's scores by department (like Marketing, Accounting, Finance, etc

www.youtube.com