Hi,
I've got a row of cells containing numerical values, eg. row A1 to O1 contains 3 0 0 0 1 0 0 0 0 1 0 0 0 0 3
I need a formula which will summarise this to produce 3113 ( it must ignore the zeros).
Yours in hope,
Pontiff
I've got a row of cells containing numerical values, eg. row A1 to O1 contains 3 0 0 0 1 0 0 0 0 1 0 0 0 0 3
I need a formula which will summarise this to produce 3113 ( it must ignore the zeros).
Yours in hope,
Pontiff