Sorry I missed your formula, and is it a correct formula because
you are referencing two different rows. But between the two
responses you can probably figure out want you wanted.

Your question would be easier to read if it were like what we
would see on a spreadsheet rather than numbers and formula
scattered through a paragraph. After all that is what we would
have to do set up your problem and test it.