D
Debby
Is there a way to make a spread sheet have text symbols then convert them
into numbers at total columns?
into numbers at total columns?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
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
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
D
Debby
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?
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?
J
Jim May
you can use the formula =counta(B10:M10) in Cell N10
This will count only cells which are non-blank.
This will count only cells which are non-blank.