Most likely some cells in V3:V29 still contain text values or hidden spaces, so SUM skips them even if the format says Number. I’d test one of the missed cells with =ISNUMBER(V3) and then force-convert the range with Text to Columns or multiply by 1.
