LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default 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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make letters not show up in a alpha-numeric string? gdd6936 Excel Worksheet Functions 3 June 3rd 06 09:56 PM
Sepearting Numeric Data from Letters jstock Excel Discussion (Misc queries) 1 April 25th 06 06:26 AM
using network paths rather than drive letters in microsoft query samwardill Excel Discussion (Misc queries) 2 March 8th 06 01:10 PM
Numeric content in one cell ( implicit formula ) and the result in another one PeDevillers Excel Discussion (Misc queries) 7 March 2nd 05 07:40 AM
Reflect file path (show drive letters) in Excel 2000 Alicia Excel Discussion (Misc queries) 4 January 20th 05 06:49 PM


All times are GMT +1. The time now is 04:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"