How to autofill number depending on next column and cell(number-1)?

0
votes

I am looking for a Google Sheets formula to autofill number depending on next column and cell(number-1) like this:

requirement

I've tried using =if(ISBLANK(C11);"";ROW(B11)-8) but the result is like:

attempt

What is the right formula?

1
google-sheetsgoogle-sheets-formula
Hello! Please can you give an example of your desired output. The two pictures above are identical and, according to your post, not what you want. – Paul
@Paul compare the 2nd pic with the others, on the 2nd pick I have two 7 number that i want to make it 6 on first same number with formula – flix
Got it - so you want a cumulative total of how many rows have been filled up so far? – Paul

1 Answers

1
votes

You can use this:

=IF(B1<>"";COUNTA(INDIRECT("B1:B"&row()));)

As in this image: enter image description here

Link to working copy

Link

Is this what you where trying to do?