The thing is that if those entries were in your original sheet, I think your formula (that you already have there) would give you the correct result. Unless the setup of your workbook is not like your original sample.

I am confused as to why you think that the formula is wrong.