Hi Pecoflyer,
I modified what you gave me slightly and it worked perfectly except I need this formula to work "left to right"...going from Column "U" towards Column "A" so it SUMS cells going from U2 towards A2 (in this example) until a cell containing value "0" is found.
Can you adjust the formula below to do this? Thank you again.
=SUM(OFFSET(A2,,,,MATCH(0,A2:U2,0)))