Rank function ignoring zero and negative values

Hello,

I'm trying to rank the values in row 94 while ignoring zeros and negative values. I've input the following formula into the cells in row 95:
=IF(D94,RANK.EQ(D94,$D$94:$AY$94,0)-COUNTIF($D94:$AY94,"<=0"),"")

Unfortunately, the ranking values in row 95 are incorrect and some of them come out as negative numbers. Is there a way to fix my formula so the correct rankings are output in row 95? Thanks.

Thanks Richard, that worked.

I have a follow-up question. Is it possible to rank the values in row 94 while ignoring only the zero values? I'd like the function to rank the values in descending order, beginning with the most positive value and ending with the most negative value while ignoring all zeros.

Unfortunately that didn't work. I've attached a simplified version of the spreadsheet for reference.