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