One way (Array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(--LEFT(B1:B10,1))


In article .com,
jfcby wrote:

Hello,

My worksheet cell data B3 - looks like the below example:

Column B
Row 1: 4 (24X24X6)
(Includes Future)
Row 2: 5 (24x24x6)
Row 3: 4 (24x24x6)
Row 4: 5 (24x24x6)
Row 5: 3 (24x25x6)
(Includes Future)
Row 6: 4 (24x24x6)
Row 7: 5 (24x24x6)
(Includes Future)
Row 8: 6 (24x24x6)
Row 9: 6 (24x24x6)
Row 10: 6 (24x24x6)

My cells are formatted wrap text.

I'm trying to sum all my cells with the first number. My formula that
I'm using is:

Formula 1 - did not work
=SUM(LEFT(B3:B12,1))

Formula 2 - did not work
=SUM(LEFT(B3,1:B12,1))

Formula 3 - did not work
=SUM(LEFT(B3, 1):Left(B12,1))

Each formula give this error: "This formual you typed contains an
error"

How can the formula be changed to sum a column of data as described
above?