add new criteria to formula

Try

Formula:

Please Login or Register  to view this content.

i.e. this will replace 1 in the numerator.
($I$6:INDEX($I:$I,MATCH(1E+100,$I:$I))=2)

May we have a representative Excel workbook upload that is producing this error? (not a pic or screenshot ... saves retyping data)

If you are not familiar with how to do this, (the paperclip icon does not work):

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

Thanks for the upload skipro. Try this. The #N/A is gone. Is now 66.5

Formula:

Please Login or Register  to view this content.

Needed to change the column that defined the I:I range. It had blanks and text in what is mostly numeric. The rest of the formula is a guess at what the intent is.

Does this help?

You need to be specific: state two or three cells where the result is wrong and tell us what you think it should be. "Does not give accurate figures" is too vague.