Using different values for a cell

[Kribulin]

Okey, I don't think my problem is very complicated, but it's seems to be difficult to explain, so I have tried to make it clearer with the help of a picture.

My setup is the following:

I have a very long list of values in a column (column J). All these values are calculated in accordance with an input value, which is currently given in a single cell (P3).
This is the code of the first cell in the J-column:

=WENN(H2+F3>$P$3;(H2+F3)-$P$3;0)

Now I would like to make a new column, where the first cell calculates the sum of the original column for an input value "0".
Then the second cell in this column calculates the of the original column for an input value "100".
Then the same with an input value 200, then 300 and so on.

 

[Kribulin]

First of all, thank you for helping.

I've been trying to apply this to my sheet, but is still not allright. The received values are indeed now close to the correct ones, so I suppose it's just a small error somewhere.

I've tried to remove as much unnecessary material as possible from my sheet; do you think you could have a look on it? (I'm aware it's still big). It's the "WD_year" tab.

Thanks you once again!

http://www.uploading.com/files/9THT75WH/Model_extratemp.xls.html

 

[Kribulin]

So this is the formula in M3 now looks like:

={SUMME(WENN((WENN(G$3:G$17523>L3;L3;G$3:G$17523)+F$3:F$17523)>L3;(WENN(G$3:G$17523>L3;L3;G$3:G$17523)+F$3:F$17523)-L3;0))}

 

[Andrew Poulsom]

If you can find a way to calculate column J without using column H, I will be able to help you further.

 

[Kribulin]

I'm not sure if I can manage that, but I'll think it over. Thank you!