Sum/count until a certain value is reached

[sreejeshc]

I have got a set of data for which i need to count/sum for the below example

cell A1 to A10 contains values; 1 1 1 1 1 0 0 1 1 0
Now i need to sum/count the values of the range until it reaches the first 0 (zero). Here it would give 5

[gak67]

Please Login or Register  to view this content.

[sreejeshc]

Perfect !!....thanx

[:) Sixthsense :)]

Or

=SUM(A1:INDEX(A1:A10,MATCH(0,A1:A10,0)-1))