Converting a symbol to a numeric value?

[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?

 

[RagDyer]

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")

 

[Guest]

instead of using auto sum use =counta(range)
This formula counts all entries regardless if numeric or non-numeric

 

[Guest]

Thanks, that worked a treat!

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")

 

[Guest]

Thanks for the info.

instead of using auto sum use =counta(range)
This formula counts all entries regardless if numeric or non-numeric

 

[RagDyeR]

Thank you for the feed-back.

 

[Need To Know]

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.

 

[Gord Dibben]

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