| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need a formula that will calculate a cell of text.
I am creating a tracking worksheet of employees. I want to have a cell next
to their name(s) that automatically enters a value of 1. Then I can have a sum at the end of the list that tells me how many individuals I have in a particular category. Regardless of what text is in the cell I want the result to calculate 1. I found a formula that counts words in a cell, but I always want it to be 1. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a formula that will calculate a cell of text.
an option
=count(A1:A10) Range is equal to category HTH "Dixie" wrote: I am creating a tracking worksheet of employees. I want to have a cell next to their name(s) that automatically enters a value of 1. Then I can have a sum at the end of the list that tells me how many individuals I have in a particular category. Regardless of what text is in the cell I want the result to calculate 1. I found a formula that counts words in a cell, but I always want it to be 1. Is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a formula that will calculate a cell of text.
Ray,
I entered the formula and the result was zero. Any other options? "Ray A" wrote: an option =count(A1:A10) Range is equal to category HTH "Dixie" wrote: I am creating a tracking worksheet of employees. I want to have a cell next to their name(s) that automatically enters a value of 1. Then I can have a sum at the end of the list that tells me how many individuals I have in a particular category. Regardless of what text is in the cell I want the result to calculate 1. I found a formula that counts words in a cell, but I always want it to be 1. Is this possible? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a formula that will calculate a cell of text.
Sorry Dixie
The count function is for numeric numbers Use =counta(a1:a100) "Dixie" wrote: Ray, I entered the formula and the result was zero. Any other options? "Ray A" wrote: an option =count(A1:A10) Range is equal to category HTH "Dixie" wrote: I am creating a tracking worksheet of employees. I want to have a cell next to their name(s) that automatically enters a value of 1. Then I can have a sum at the end of the list that tells me how many individuals I have in a particular category. Regardless of what text is in the cell I want the result to calculate 1. I found a formula that counts words in a cell, but I always want it to be 1. Is this possible? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need a formula that will calculate a cell of text.
Thank you!!!!!!!!! It worked beautifully, just what I need!!!!!!
"Ray A" wrote: Sorry Dixie The count function is for numeric numbers Use =counta(a1:a100) "Dixie" wrote: Ray, I entered the formula and the result was zero. Any other options? "Ray A" wrote: an option =count(A1:A10) Range is equal to category HTH "Dixie" wrote: I am creating a tracking worksheet of employees. I want to have a cell next to their name(s) that automatically enters a value of 1. Then I can have a sum at the end of the list that tells me how many individuals I have in a particular category. Regardless of what text is in the cell I want the result to calculate 1. I found a formula that counts words in a cell, but I always want it to be 1. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate with formula results after formatting with =TEXT | Excel Worksheet Functions | |||
| Calculate a formula when enter text | Excel Worksheet Functions | |||
| excel text formula does not calculate after editing | Excel Worksheet Functions | |||
| Calculate value in a text filled cell | Excel Worksheet Functions | |||
| calculate a formula instead of returning text | Excel Worksheet Functions | |||
Linear Mode
