Hello,
I have some data that I want to add up cumulatively but it has a condition on its date of operation in other columns
for instance;
[TABLE="width: 476"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1234[/TD]
[TD]1990[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]673[/TD]
[TD]1990[/TD]
[TD]1997[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2134[/TD]
[TD]1991[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7878[/TD]
[TD]1992[/TD]
[TD]1996[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0[/TD]
[TD]1992[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]567[/TD]
[TD]1994[/TD]
[TD]1999[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]0[/TD]
[TD]1996[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]43[/TD]
[TD]1998[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]346[/TD]
[TD]1998[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]0[/TD]
[TD]1999[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Column A is facility, B is amount produced, C is year opened and D is year shut (blank if not shut)
I want to produce a result that will allow me to cumulatively add up production year by year, 1990, then 1991 in the row below, 1992 below that etc, all beginning from 1990.
I can do that bit, but I am running into problems as when I get to say 1998, the sites that shut in 1996 can only be included up to 1996, they have to stop being counted in 1997 and 1998. Blank cells are also causing a problem in SUMIF (not sure 0 is acceptable in the final presentation)
thanks for your help
S
I have some data that I want to add up cumulatively but it has a condition on its date of operation in other columns
for instance;
[TABLE="width: 476"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1234[/TD]
[TD]1990[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]673[/TD]
[TD]1990[/TD]
[TD]1997[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2134[/TD]
[TD]1991[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]7878[/TD]
[TD]1992[/TD]
[TD]1996[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0[/TD]
[TD]1992[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]567[/TD]
[TD]1994[/TD]
[TD]1999[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]0[/TD]
[TD]1996[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]43[/TD]
[TD]1998[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]346[/TD]
[TD]1998[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]0[/TD]
[TD]1999[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Column A is facility, B is amount produced, C is year opened and D is year shut (blank if not shut)
I want to produce a result that will allow me to cumulatively add up production year by year, 1990, then 1991 in the row below, 1992 below that etc, all beginning from 1990.
I can do that bit, but I am running into problems as when I get to say 1998, the sites that shut in 1996 can only be included up to 1996, they have to stop being counted in 1997 and 1998. Blank cells are also causing a problem in SUMIF (not sure 0 is acceptable in the final presentation)
thanks for your help
S