Use this =SUMPRODUCT(--SUBSTITUTE(B2:B40,CHAR(160),0))