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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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

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

"Scrap Monkey" wrote:

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?

Thanks, that worked a treat!

"RagDyer" wrote:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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

Thanks for the info.

"sjk153" wrote:

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

"Scrap Monkey" wrote:

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?

Thank you for the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Scrap Monkey" wrote in message
...
Thanks, that worked a treat!

"RagDyer" wrote:

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

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

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

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.

"Scrap Monkey" wrote:

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?

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
wrote:

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.

"Scrap Monkey" wrote:

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?