I have tried the following formula as suggested by your discussion group Feb4,

=sum(WS2!$A$1:index(WS2!$A1:$L1,countif($A1:$L1," "&0))).

The formula should add the values of cells WS2(A1:L1) only if there is a
value 0 in (A1:L1). ie: if WS2 A1=200 and WS2 B1=150 and WS2 (C1:L1) are all
0 then the formula should render the value 350. This formula as written above
is adding all of the cells (WS2A1:L1) even if the values of (A1:L1) are all
0. Note that when I have referenced (A1:L1) it refers to WS1 not WS2. I
appreciate your help with this formula so that it only adds when any of the
cells in (A1:L1) are 0. Thanks very much.
--
Brian