Put a formula in a cell to add a row of ticks

I

Irene

How do I add a column of cells which have a tick in them
and end up with a total shown as a number?
 
R

Rick C

Irene,
By the word "tick", I'm not sure which character you are using, but the
following formula is for the grave accent (`), which is generally on the
same key with the tilde (~) symbol.

=COUNTIF(A1:A10,"`")

You probably don't want to use characters like the apostrophe (') or the
dash (-) or the slash (/) because of the special way Excel treats those
characters.

hth,
Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a checklist with predefined comments 1
Copy addition formula of non-consecutive horizontal cells 2
Cell data entering slow! 0
Newbie Help - IF Yes No Function 0
ticking box 1
Show a tick mark for a positive test result 9
Tick mark 3
Excel does not accept text format! 0

Top