Osvaldo Palmeiro
Well-known Member
- Joined
- Feb 24, 2009
- Messages
- 752
- Office Version
- 365
- Platform
- Windows
Hi all.
Please, I would like to count via formula the number of occurrences based on two criteria: same points AND same ages for each couple.
The formula should not refer to a specific value of points or a specific age, nor should refers to the cell rows that holds those data, but should adopt the equalities of points and ages as criteria.
Appreciate any help.
Thanks in advance.
Please, I would like to count via formula the number of occurrences based on two criteria: same points AND same ages for each couple.
The formula should not refer to a specific value of points or a specific age, nor should refers to the cell rows that holds those data, but should adopt the equalities of points and ages as criteria.
Appreciate any help.
Thanks in advance.
Cópia de Cópia de Ranking x5 2.0-1 V2.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | name1 | name2 | points | age | couples | count ocurrences (expected results) | |||||
2 | John | Anne | any points xx | any age aa | John | Anne | 2 | ||||
3 | Mike | Anne | any points ww | any age | Mike | Mary | 3 | ||||
4 | John | Mary | any points | any age | |||||||
5 | Mike | Mary | any points yy | any age mm | |||||||
6 | John | Anne | any points xx | any age aa | |||||||
7 | Mike | Mary | any points | any age | |||||||
8 | John | Anne | any points bb | any age | |||||||
9 | Mike | Mary | any points yy | any age mm | |||||||
10 | John | Mary | any points | any age | |||||||
11 | Mike | Mary | any points yy | any age mm | |||||||
12 | |||||||||||
Planilha1 |