Excel sum based on array

Vote count:

0

I'm trying to make a validation if in the competition of badminton a setup is valid. A setup is valid if the sum of the 2 player rankings is higher or equal then the sum of the players below

ranking is as following:

A, B1, B2, C1, C2, D with A being the highest en D being the lowest

This is probably easiest by giving D an index code of 1, and C2 = 2, ..., A = 6

when you have this setup:

+---------+---------+
| Name    | ranking |
+---------+---------+
| player1 |    A    |
| player2 |    B2   |
+ --------+---------+
| player3 |    B1   |
| palyer4 |    B1   |
+---------+---------+

So in excel how can I validate that the sum of player 1 & 2 is higher or equal then the sum of player 3 & 4

asked 45 secs ago

Kiwi

369

Excel sum based on array