Formulas
 

Is there a way to make a spread sheet have text symbols then convert them
into numbers at total columns?

Formulas
 

Probably.

With more detail on what the "text symbols" are and what you want to do with
them you could get a more definitive answer.


Gord Dibben MS Excel MVP

On Thu, 14 Sep 2006 10:23:02 -0700, Debby
wrote:

Is there a way to make a spread sheet have text symbols then convert them
into numbers at total columns?

Formulas
 

The problem is that I have a spread sheet that has months on left side giong
done and dates 1 thorugh 31 on top. Then I am placing a letter in the column
for the type of abscenes an employee took. But it the total for the month
across I want it to add 1 for each letter and come up with a total that can
be subtracted from the orginal top total as for vacation. Can the letter per
cell represent a number 1 to be added at the end of the column?

"Gord Dibben" wrote:

Probably.

With more detail on what the "text symbols" are and what you want to do with
them you could get a more definitive answer.


Gord Dibben MS Excel MVP

On Thu, 14 Sep 2006 10:23:02 -0700, Debby
wrote:

Is there a way to make a spread sheet have text symbols then convert them
into numbers at total columns?

Formulas
 

you can use the formula =counta(B10:M10) in Cell N10
This will count only cells which are non-blank.



"Debby" wrote:

The problem is that I have a spread sheet that has months on left side giong
done and dates 1 thorugh 31 on top. Then I am placing a letter in the column
for the type of abscenes an employee took. But it the total for the month
across I want it to add 1 for each letter and come up with a total that can
be subtracted from the orginal top total as for vacation. Can the letter per
cell represent a number 1 to be added at the end of the column?

"Gord Dibben" wrote:

Probably.

With more detail on what the "text symbols" are and what you want to do with
them you could get a more definitive answer.


Gord Dibben MS Excel MVP

On Thu, 14 Sep 2006 10:23:02 -0700, Debby
wrote:

Is there a way to make a spread sheet have text symbols then convert them
into numbers at total columns?