Ranking Positive and Negative Numbers in a Column

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Assuming that you want to use the formulas to populate the Risk and Risk2 columns, try the following:
For Risk: =IF(OR(E5="",E5<=0),"",SUMPRODUCT((E$5:E$8>0)*(E$5:E$8<>"")*(E$5:E$8>E5))+1)
For Risk2: =IF(OR(E5="",E5>=0),"",SUMPRODUCT((E$5:E$8<0)*(E$5:E$8<>"")*(E$5:E$8>E5))+1)
A more robust demonstration of the formulas is in rows 14:20
Let us know if you have any questions.