Hi,


I'm tyring to find a way to sum a series of cells in a single row until a cell is reached who's value = 0.

Example:

Row1 cells (columns A thru D then E contains "0")

A=1; B=3; C=7; D=9. Then a "0" is detected in cell Column E of row1 so only values A,B,C,D are summed equaling 20.

There are multiple rows (35 altogether) and the "0" can show up in any column A thru U or not at all.

thank you.
Sunnyside