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 |