Modify SUM

I have this SUM formula that is working, but I need to add a two more conditions and I can't seem get it right.
=SUM(IF(L2:L20000="",0,1)*IF(Q2:Q20000="selected",1,0)*IF(LEFT(L2:L20000,1)>RIGHT(L2:L20000,1),1,-1/(I2:I20000-1)))

I need to add two more conditions to the last IF

I want the last IF to be true only if H2:H20000 is greater than 1.2, and to be false only if I2:I20000 is greater than 1.2. In any other cases I want it to be 0
Keep in mind that this is an array formula
I'm sorry if I explained poorly, if it's too difficult I'll attach an example sheet.




TY

Thanks for replying, the your solution is working correctly but it does not have the two conditions that I have mentioned
the last IF should be true only if H2:H10 is also greater than 1.2 and false only if I2:I10 is also greater than 1.2

this is my non-array formula that if applied to a whole column and then summed up, gives the result that I'm looking for.

Please Login or Register  to view this content.

What I am trying to do is get everything into one cell, with an array formula.

Sorry for being ambiguous

I've attached an example sheet
sum is the sum that I am looking for with my newbie solution.
sum2 is the solution that Ron Coderre suggested
sum3 is a variant of his solution, same result

I've tested it a bit and it seems to be giving wrong results and I can't really change it as I'm not familiar with the CHOOSE and SIGN functions.

This is an archive of John Isner's past ~150 matches , I'm sure you've heard of him since he's the top ranked US tennis player.
My formula says that
IF the F cell is not blank, Q cell is "selected" , the L cell( set score) is positive - (as in he won the match) and the H column is greater then 1.2, then the value is 1

if not, if the L cell is not blank, Q is selected, the set score is negative (as in he lost the match), and the I cell is greater than 1.2, then value is -1/(i3-1)

That's spot on, many thanks!