I am trying to find the maximum value in 4th column when 3 other criteria is met in 3 other columns. Here is my equation below...
=MAX(ifs($C$1:$C$289774=M1)*($D$1:$D$289774=N1)*($E$1:$E$289774=O1),$I$1:$I$289774)
The maximum value I am searching for is in "column I", but I need the criteria in column c, column d, and column e already met. The maximum value for all of these criteria would show up in column P
[TABLE="width: 1024"]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl64, width: 64"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="class: xl65, width: 64"]A[/TD]
[TD="class: xl65, width: 64"]B[/TD]
[TD="class: xl65, width: 64"]C[/TD]
[TD="class: xl65, width: 64"]D[/TD]
[TD="class: xl65, width: 64"]E[/TD]
[TD="class: xl65, width: 64"]F[/TD]
[TD="class: xl65, width: 64"]G[/TD]
[TD="class: xl65, width: 64"]H[/TD]
[TD="class: xl65, width: 64"]I[/TD]
[TD="class: xl65, width: 64"]J[/TD]
[TD="class: xl65, width: 64"]K[/TD]
[TD="class: xl65, width: 64"]L[/TD]
[TD="class: xl63, width: 64"]M[/TD]
[TD="class: xl63, width: 64"]N[/TD]
[TD="class: xl64, width: 64"]O[/TD]
[TD="width: 64, align: center"]P[/TD]
[TD="class: xl65, width: 64"]726430[/TD]
[TD="class: xl65, width: 64"]14920[/TD]
[TD="class: xl65, width: 64"]1933[/TD]
[TD="class: xl65, width: 64"]5[/TD]
[TD="class: xl65, width: 64"]22[/TD]
[TD="class: xl65, width: 64"]17[/TD]
[TD="class: xl65, width: 64"]0[/TD]
[TD="class: xl65, width: 64"]85[/TD]
[TD="class: xl65, width: 64"]66[/TD]
[TD="class: xl65, width: 64"]1700[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl63, width: 64"]1933[/TD]
[TD="class: xl63, width: 64"]5[/TD]
[TD="class: xl64, width: 64"]22[/TD]
[TD="width: 64, align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]52[/TD]
[TD="class: xl65"]51[/TD]
[TD="class: xl65"]900[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1934[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]17[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]78[/TD]
[TD="class: xl65"]55[/TD]
[TD="class: xl65"]1700[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1935[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]13[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]60[/TD]
[TD="class: xl65"]55[/TD]
[TD="class: xl65"]1300[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1936[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]21[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]86[/TD]
[TD="class: xl65"]69[/TD]
[TD="class: xl65"]2100[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1937[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]65[/TD]
[TD="class: xl65"]52[/TD]
[TD="class: xl65"]500[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1938[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]64[/TD]
[TD="class: xl65"]58[/TD]
[TD="class: xl65"]900[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1939[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]13[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]70[/TD]
[TD="class: xl65"]59[/TD]
[TD="class: xl65"]1300[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1940[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]79[/TD]
[TD="class: xl65"]63[/TD]
[TD="class: xl65"]100[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1941[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]17[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]83[/TD]
[TD="class: xl65"]65[/TD]
[TD="class: xl65"]1700[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1942[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]2[/TD]
[TD="class: xl65"]21[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]83[/TD]
[TD="class: xl65"]69[/TD]
[TD="class: xl65"]2100[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1943[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]5[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]66[/TD]
[TD="class: xl65"]63[/TD]
[TD="class: xl65"]500[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1944[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]9[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]64[/TD]
[TD="class: xl65"]63[/TD]
[TD="class: xl65"]900[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1945[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="class: xl65"]726430[/TD]
[TD="class: xl65"]14920[/TD]
[TD="class: xl65"]1933[/TD]
[TD="class: xl65"]6[/TD]
[TD="class: xl65"]3[/TD]
[TD="class: xl65"]13[/TD]
[TD="class: xl65"]0[/TD]
[TD="class: xl65"]70[/TD]
[TD="class: xl65"]66[/TD]
[TD="class: xl65"]1300[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl63"]1946[/TD]
[TD="class: xl63"]5[/TD]
[TD="class: xl64"]1[/TD]
[TD="align: center"]#VALUE![/TD]
[/TABLE]
Thanks in advance for the help!
Jeff