ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   formula needed to sum check marks (https://www.excelbanter.com/excel-worksheet-functions/131970-formula-needed-sum-check-marks.html)

veena

formula needed to sum check marks
 
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?

Bernard Liengme

formula needed to sum check marks
 
=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

"veena" wrote in message
...
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?




All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com