Results 1 to 7 of 7

Ranking with SUMPRODUCT

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2020
    Location
    Sao Paulo
    MS-Off Ver
    2016 (macOS)
    Posts
    12

    Ranking with SUMPRODUCT

    Hi!

    I'm trying to figure out how a "conditional ranking" is working on a spreadsheet that I'll attach to this thread. I want to learn/understand so I can apply this on different situations, the part that confuses me the most is the "*10^-6".

    Basically, there are two formulas on this spreadsheet:

    Ranking two criteria
    =SUMPRODUCT(--(($C$3:$C$5+$D$3:$D$5*10^-6)>C3+D3*10^-6))+1
    Captura de Tela 2021-12-26 ās 23.21.48.png

    Ranking three criteria
    =SUMPRODUCT(--(($C$10:$C$20+$D$10:$D$20*10^-3+$E$10:$E$20*10^-6)>C10+D10*10^-3+E10*10^-6))+1
    Captura de Tela 2021-12-26 ās 23.22.04.png

    Could anyone help understand this SUMPRODUCT?
    Attached Files Attached Files
    Last edited by Sakrammentum; 12-27-2021 at 06:23 AM. Reason: Added spreadsheet

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Ranking with RANK and SUMPRODUCT based on Two Value Columns
    By Newmord in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2018, 03:01 PM
  2. [SOLVED] Ranking with Sumproduct Problem with #N/A
    By mbshafe in forum Excel General
    Replies: 4
    Last Post: 01-28-2016, 04:47 AM
  3. Sumproduct to calculate ranking And match right column
    By vascobmcastro in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-19-2015, 10:55 AM
  4. ranking with sumproduct or countifs with multiple criteria
    By cwchan220 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2014, 04:12 PM
  5. Sumproduct ranking works on one column but not another
    By jenncess in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2013, 02:21 PM
  6. [SOLVED] Ranking with sumproduct without duplicates
    By luke11111 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-27-2013, 02:37 PM
  7. Conditional ranking using the Sumproduct function
    By helium in forum Excel General
    Replies: 3
    Last Post: 07-04-2012, 08:26 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1