Rank list excluding certain criterias

Help!

I have 3 columns:
a) Security Types (e.g Equity, Currency, Options, etc...)...column E in the example
b) Long or Short positions (denoted by "L" and "S")...column H in the example
c) P&L performances (in %)...column U in the example

I'm trying to rank a list of stock's monthly P&L performances, but excluding ones that are short positions (column b) and ones that are currency positions (column c). I did the following formula

=IF(AND(H12="L",E12<>"Currency"),1+SUMPRODUCT(($H:$H=H12)*($U:$U>U12)),"N/A")

I copied down this column and although it excludes currency from the ranking, it merely 'skips' the number. for example, a currency P&L would have had a ranking of 7, but I have excluded that. However, the ranking will go 1...2...3...4...5....6...8 for the equities.

Can anyone help on this?

thanks

Thank you so much! works exactly as intended