Search:

One other option if nesting within a vlookup is offputting to you would be to change the formula in H3 to below. Your lookup list is based off 2 decimal points
=ROUND(SUM(L5:L6),2)

"IF(AND" should be "IF(OR". With AND both need to be blank to return blank. Thanks

=Rounddown(cell,-1)
Example =rounddown(456,-1)
Will show as 450. The number after the negative sign is how many places prior to the decimal point (to the left) will be rounded down.

Thanks

Formula in the second column is
=COUNTIF($A$1:A1,A1)