Hi,

I presume you do mean 'count' as in your title rather than 'sum' as in your text. Assuming you mean the dot is the webdings character number 7 then just

=COUNTIF(A:A,CHAR(7))