I need to add a range of cells until I reach a cell with a zero va

G

Guest

And then start again. Example c1=1,c2=1,c3=1,c4=0 value = 3 (c1-c3) lets say
c5=1,c6=0 new value =1(c5)
 
B

Bob Phillips

D2: =MAX(1,MAX(IF(C$1:C2="",ROW(C$1:C2))))

which is an array formula, so commit with Ctrl-Shift-Enter, not justr enter

E2: =IF(AND(C2<>0,C3=0),SUM(INDIRECT("C"&D2&":C"&ROW())),"")

copy D2 and E2 down.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Same =rand() value in two adjacent cells in column 2
=SUMPRODUCT((C481:C507<>"")/COUNTIF(C481:C507,C481:C507&"")) 3
Cell offset issue 3
adding in multiple numbers when on cell is Blank 5
need a conditional formula to generate numbers divisible by 4 between a given starting no. & end No. 5
Help with IF statement check value in multiple cells 1
I need a formula to add numbers to the result in same cell. 1
change cell color depending on two cell values 1

Top