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
|