Converting a symbol to a numeric value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to use a 'tick' symbol in a spread sheet recording attendance. I would
like to then total the number of ticks in a row. How do I get Excel to give
each cell with a tick a value of 1 so that I can simply use the auto sum
facility at the end of the row?
 
You could format those cells to "WingDings 2".

Then, if you typed an upper case "P" (no quotes - might also mean
'present'<g>),
You'd display a tick.

Then, *don't add* them, COUNT them instead.

=COUNTIF(A1:K1,"P")
 
instead of using auto sum use =counta(range)
This formula counts all entries regardless if numeric or non-numeric
 
Thanks, that worked a treat!

RagDyer said:
You could format those cells to "WingDings 2".

Then, if you typed an upper case "P" (no quotes - might also mean
'present'<g>),
You'd display a tick.

Then, *don't add* them, COUNT them instead.

=COUNTIF(A1:K1,"P")
 
I am a novice and can only do simple calculations. I am wanting to set up a
scoresheet for bowling and do not know how to tell a cell X has a value of 10
and to calculate the next to cells. I need information in very basic terms
if possible and I need to know how to excel / is a symbol spare worth 10
plus value of next cell. Anyone know how to do this in very basic tems for
directions or illustrtations. Thanks for any help form anyone.
 
Not quite that simple.

What if you have four strikes in a row then a spare then a count of 8?

What was the count on the first ball of your spare frame?


Gord Dibben MS Excel MVP


On Thu, 15 Oct 2009 08:37:59 -0700, Need To Know <Need To
 
Back
Top