V
vaipen
Guest
Every half year of groceries adds up to a total. That total needs to be compared to all the previous half year periods. The totals are fixed, do not change. I need to calculate the positive or negative difference or 'more or less than' period 1, 2...etc. So, first half year 2009 compared to all periods before.
E.g.
2006 = 550
2007 = 600
2008 = 900
2009 = 850, changed from 2006 = +300, change from 2007 =+250, change from 2009 = -/- 50.
The half year totals are each in a separate sheet. Every half year a new sheet is added.
E.g.
2006 = 550
2007 = 600
2008 = 900
2009 = 850, changed from 2006 = +300, change from 2007 =+250, change from 2009 = -/- 50.
The half year totals are each in a separate sheet. Every half year a new sheet is added.