Excel sum function w/ footage numbers.

Question

Is there a way to sum footage numbers? Such as 12'+ 12'+++ in a column that also has multiple empty cells.

Answer 1

Assuming your data range is A2:A10, then give this array formula to get results.

=SUM(IF(A2:A10="",0,LEFT(A2:A10,LEN(A2:A10)-1)*1))

Array formula is entered by pressing CTRL+Shift+Enter all simultaneously.

Answer 2

Hi,

try this ,Enter below formula ,Press Ctrl+Shift+Enter , instead of Enter 

=SUMPRODUCT(IFERROR(SUBSTITUTE(A2:A10,"'","")+0,0))

Hope it helps

Regards

Answer 3

An example of what you have and what you would expect from the example would be useful in helping you.

12/2 Wire
12'
12'
12'
12'
12'
=total footage

Thanks for taking a look Bernie.

Answer 4

An example of what you have and what you would expect from the example would be useful in helping you.