| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Ignoring the contents of cells when there are letters in thecell
When using MS Works I can enter letters and numbers in a cell and the total of the cells in a row will be calculated correctly(for my particular requirement) by ignoring anyone of the cells in the row which has letters and numbers together. All the cells are formated as 'General'.
When I try to do this task in Excel it gives an error in the result cell. Note that any cell may have a mixture of letters and cells. Any help would be appreciated. Thank you James Submitted via EggHeadCafe - Software Developer Portal of Choice Bing Search RSS with Silverlight 3 RIA Domain Service http://www.eggheadcafe.com/tutorials...with-silv.aspx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to sort part numbers, sometimes ignoring leading letters | Excel Discussion (Misc queries) | |||
| Excel - Geomean - Ignoring Empty Cells | Excel Worksheet Functions | |||
| Ignoring a cell contents | Excel Discussion (Misc queries) | |||
| sort a range of numbers ignoring preceding letters | Excel Discussion (Misc queries) | |||
| Ignoring letters behind numbers | Excel Worksheet Functions | |||
Threaded Mode
