Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
letters drive a numeric result
one of the segments to this worksheet includes 12 boxes where users would
enter one of 4 letters. E,S,O or R. E being the most valuable then S then O then R. Im trying make excell produce a numeric result (1 - 100) based on how many of the boxes are filled with one of the four letters. I had though to use a COUNTIF formula but that doesnt seem to work. Please help!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
letters drive a numeric result
You actually were correct. use:
=COUNTIF($A$1:$A$12,"E") =COUNTIF($A$1:$A$12,"S") =COUNTIF($A$1:$A$12,"O") =COUNTIF($A$1:$A$12,"V") to count the respective letters. Adjust the block-of-cells to match your structure -- Gary''s Student gsnu200707 "mblush" wrote: one of the segments to this worksheet includes 12 boxes where users would enter one of 4 letters. E,S,O or R. E being the most valuable then S then O then R. Im trying make excell produce a numeric result (1 - 100) based on how many of the boxes are filled with one of the four letters. I had though to use a COUNTIF formula but that doesnt seem to work. Please help!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
letters drive a numeric result
Great! knew it was a small thing! now, lets say I wanted to place a value to
the letters, for instance; E = 4 S = 3 O = 2 R = 1 Can I make the COUNTIF function do this automatically? or is there another function I should apply to the result of the COUNTIF? "Gary''s Student" wrote: You actually were correct. use: =COUNTIF($A$1:$A$12,"E") =COUNTIF($A$1:$A$12,"S") =COUNTIF($A$1:$A$12,"O") =COUNTIF($A$1:$A$12,"V") to count the respective letters. Adjust the block-of-cells to match your structure -- Gary''s Student gsnu200707 "mblush" wrote: one of the segments to this worksheet includes 12 boxes where users would enter one of 4 letters. E,S,O or R. E being the most valuable then S then O then R. Im trying make excell produce a numeric result (1 - 100) based on how many of the boxes are filled with one of the four letters. I had though to use a COUNTIF formula but that doesnt seem to work. Please help!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
letters drive a numeric result
Actualy I have that figuered out as well! thanks alot! occassionally the ole'
noodle needs a Jumpstart! "Gary''s Student" wrote: You actually were correct. use: =COUNTIF($A$1:$A$12,"E") =COUNTIF($A$1:$A$12,"S") =COUNTIF($A$1:$A$12,"O") =COUNTIF($A$1:$A$12,"V") to count the respective letters. Adjust the block-of-cells to match your structure -- Gary''s Student gsnu200707 "mblush" wrote: one of the segments to this worksheet includes 12 boxes where users would enter one of 4 letters. E,S,O or R. E being the most valuable then S then O then R. Im trying make excell produce a numeric result (1 - 100) based on how many of the boxes are filled with one of the four letters. I had though to use a COUNTIF formula but that doesnt seem to work. Please help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make letters not show up in a alpha-numeric string? | Excel Worksheet Functions | |||
Sepearting Numeric Data from Letters | Excel Discussion (Misc queries) | |||
using network paths rather than drive letters in microsoft query | Excel Discussion (Misc queries) | |||
Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) |