count and match

[Pammy]

Excel 2007

I have a spreadsheet with 7 columns and 253 rows, one of the columns has a
checkmark if the person responded. I want to filter out all the checkmarks
and do a count on these and put these on a black spreadsheet and leave the
original in tact. I cannot figure this out in excel 7, please help.

 

[Bob Umlas, Excel MVP]

We need to know what you're using for a checkmark...

 

[Pammy]

the font marlett and a checkmark is when I type lower case b

 

[Herbert Seidenberg]

Excel 2007 Advanced Filter
No need to identify symbol.
http://www.mediafire.com/file/z1eetwwlgmx/11_18_09.xlsx