Assume the numbers start in cell B1.

Enter this formula in C2 and copy down as needed:

=IF(B2<0,"",SUM(B$1:B2)-SUM(C$1:C1))

--
Biff
Microsoft Excel MVP


"TFMR" wrote in message
...
Hi Shane,

Here is an example:

A B C
AS 1
AD 6
AD 8
AE 0 15
AE 2
AG 5
AG 1
AG 0 8
AE 9
AR 4
AA 0 13

Hope it will clear the concept.

"Shane Devenshire" wrote:

Hi,

It would be nice to see a sample of the data with what you want as the
result.

Possible if your data is in column A and the 0's are in column B

=SUMIF(B1:B100,0,A1:A100)

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire

"TFMR" wrote:

Dear All,

I have column with numeric data, I want the sum when value 0 come in
column
then next sum until the value is 0.

Thnx & Regards