SUMIF formula of precedeing cells

[Keibri]

Hi all,

Hope all is well. I would like to ask a simple formula for the following problem I have.

Basically I have column A which consists of 1 and 0.

I would like to add a formula in column B which would produce the sum of the 1's however only the cells which precede that particular cell. That is:



A B

1 1
0
0
0
0
0
0
0
1 2
0
0
0
0
0
0
0
1 3
0
0
0
1 4

Can someone please guide me though ? Thanks a lot for your kind help

[berlan]

Hi,

In B1, try,

=IF($A1>0,SUM($A$1:$A1),"")

and copy down

[NeedForExcel]

In B1

=IF(A1<>1,"",SUMIF($A$1:A1,1,$A$1:A1))

[Keibri]

Thanks a lot guys! Both solutions worked !! Appreciate a lot

[berlan]

You're welcome