formula needed to sum check marks

V

veena

i have a column with check marks in it and i want a total for it. Is there a
formual that can count or sum this for me?
 
B

Bernard Liengme

=COUNTIF(range,"?")
where ? is the sybol you are using for a check mark - you should be able to
copy it. It could be a simple letter such as P but in Marlett font. THe
function does not care what font it is in.
best wishes
 
Top