| Home |
| Search |
| Today's Posts |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to ignore text on SUM() function...
"T. Valko" wrote...
.... seq = 1:64. Why 64? Seems like an arbitrary number smaller than the "standard" arbitrary 255 because you don't expect a string longer than 64 characters. The STRING may be longer than 64 chars, but the numeric substring at the beginning would have to be no more than 64 chars. Numeric strings of more than 64 chars aren't going to produce meaningful sums anyway. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore Text for Formula | Excel Discussion (Misc queries) | |||
| add numbers but ignore text | New Users to Excel | |||
| Function to ignore decimals | Excel Worksheet Functions | |||
| Ignore Hidden Rows in Sum Function? | Excel Discussion (Misc queries) | |||
| Ignore text Function | Excel Worksheet Functions | |||
Threaded Mode
