| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUM of alphanumeric cells
How to use SUM to sum the following cells A1:A6?
10 hours 1 hour 3 hours 123 hours 5 hours Note, row 4 (A4) is blank. /Why Tea |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SUM of alphanumeric cells
Can try this array* formula:
=SUM(IF(ISERROR(FIND(" ",A1:A6)),0,LEFT(A1:A6,FIND(" ",A1:A6)-1)*1)) *- array formula must be netered not with 'enter' but with Ctrl+Shift +Enter. It'll end up with {} around it - those may not be typed. The formula, howver, asumes that the data structure is: - number - space - something else The formula would total up all the numbers before the first space it finds in the text. On Mar 30, 8:22*am, Why Tea wrote: How to use SUM to sum the following cells A1:A6? 10 hours 1 hour 3 hours 123 hours 5 hours Note, row 4 (A4) is blank. /Why Tea |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Cells with alphanumeric data | New Users to Excel | |||
| how do I sum columns with cells that contain alphanumeric data? | Excel Worksheet Functions | |||
| Calculate number between two alphanumeric cells | Excel Discussion (Misc queries) | |||
| sum alphanumeric cells | Excel Programming | |||
| alphanumeric cells | Excel Worksheet Functions | |||
Linear Mode
