Sum of data

[TFMR]

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

 

[Shane Devenshire]

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)

 

[TFMR]

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.

 

[T. Valko]

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))