Forum Discussion
Jorge
Hello, I need help with a function: income =MAX.SI.CONJUNTO(E5:E14;D5:D14;"win";D5:D14;"excel").
returns me zero and not is because...Thank you :)
The table is :
| word | 1000 |
| word | 500 |
| win | 100 |
| excel | 800 |
| win | 850 |
| word | 950 |
| excel | 420 |
| excel | 120 |
| win | 365 |
| excel | 789
|
Hello Jorge
=MAX(MAXIFS(E5:E14,D5:D14,{"win";"excel"}))
