incremental increase by 1 in a row of cells based on values in another row

[bijalvp]

hi

i have a row of cells (60 columns, D through BK) and each of these cells has a calculated value populating it.

in another row, I want to add 1 to the cell corresponding to the cell above every time the sum of cells going left to right increases by 2000.

For. eg.

Values in row:

D2 = 2500 
E2 = 3500 
G2 = 4800 
H2 = 5600 
I2 = 6800 
J2 = 8300 
K2 = 9900 
L2 = 12000 
M2 = 16000

and so forth

In the cells below, I want a formula that can calculate and populate cells as below:

D3 = 1
E3 = 0
G3 = 1
H3 = 0
I3 = 1
J3 = 1
K3 = 1
L3 = 2
M3 = 2

I have a formula that I can use - nested IF statements but it gets very very long very very fast.

Any help will be greatly appreciated

[keme]

Not sure about the description/example correspondence here.

Assuming you want to look at the difference between adjacent cells:

• D3 = 1
  *from 0 to 2500 is an increase of 2500 - makes sense *
• E3 = 0
  from 2500 to 3500: 1000 < 2000 so 0 alo makes sense
  DATA GAP - assuming F2 empty/zero
• G3 = 1
  0 to 4800, >2000 - following the logic
• H3 = 0
  4800 to 5600, <2000
  … so far good, but then …
• I3 = 1
  5600 to 6800, <2000
• J3 = 1
  6800 to 8300, <2000
• K3 = 1
  8300 》9900, <2000
• L3 = 2
  9900 》12000, >2000, suddenly you need 2, please explain
• M3 = 2
  12000 》16000, 4000=2×2000

If I read the requst verbatim, the " … sum of cells from left to right … " increases by >2000 for every cell, for which, again, I cannot find any correspondence in the given desired result.

Perhaps if you also give us the “monster formula”…