have come across an issue with attempting to get excel to compare monthly figures from this time last year to now. I have a list of data ranging from Jan-10 to dec this year. Each date has a value for end of month data. what I want to do is add the values from Jan-11 up to what ever month we are at, and in a separate Colum add the values for the same period in 2010.
My set up looks like below for Sheet 1...
D E
Date Items
Jan-10 36
Feb-10 43
Mar-10 60
dates and data ranging through to December 2011.
IN columns B and C in sheet 1 I have used the TEXT formula to name the dates and year.
My summary page is where the data is to go, so for this year I have =SUMIF('Sheet 1'!$C$4:$C$40,Summary!$C$6,'Sheet 1'!$E$4:$E$40), which works fine for 2011 figures, but I cannot get the figures to add up for the same period last year..
I have tried Vlookup and sumproduct, but to no avail.
any help is much appreciated.
Thanks
My set up looks like below for Sheet 1...
D E
Date Items
Jan-10 36
Feb-10 43
Mar-10 60
dates and data ranging through to December 2011.
IN columns B and C in sheet 1 I have used the TEXT formula to name the dates and year.
My summary page is where the data is to go, so for this year I have =SUMIF('Sheet 1'!$C$4:$C$40,Summary!$C$6,'Sheet 1'!$E$4:$E$40), which works fine for 2011 figures, but I cannot get the figures to add up for the same period last year..
I have tried Vlookup and sumproduct, but to no avail.
any help is much appreciated.
Thanks