I have a column of data that is updated everyday with an additional value (sales by day). I have all 365 days of sales from last year. I want to be able to compare this year's YTD total with last year's corresponding YTD total. So I need to sum last year's numbers for only the same day's that I have a value for in this year.
I am also trying to do the same for a rolling 30 day period. I cannot figure out how to make this a non-manual process.
Example:
2011 2010
1/1/2011 $25,652 $63,214
1/2/2011 $36,584 $54,216
1/3/2011 $25,415 $23,695
1/4/2011 $45,218 $33,459
1/5/2011 $35,694 $56,795
1/6/2011 $25,671 $66,457
1/7/2011 $56,327 $45,269
1/8/2011 $55,429 $75,236
1/9/2011 $63,256
1/10/2011 $95,362
1/11/2011 $42,567
1/12/2011 $23,574
$305,990 $643,100
I want to add 1/1 - 1/8 in 2010 because that is the comparable YTD that I have for 2011. But I'd like to do this via some kind of formula versus summing the corresponding dates in 2010 every time. I have to do this for a wide variety of metrics so it takes too much time, i feel there has to be something more efficient!
Any suggestions?
I am also trying to do the same for a rolling 30 day period. I cannot figure out how to make this a non-manual process.
Example:
2011 2010
1/1/2011 $25,652 $63,214
1/2/2011 $36,584 $54,216
1/3/2011 $25,415 $23,695
1/4/2011 $45,218 $33,459
1/5/2011 $35,694 $56,795
1/6/2011 $25,671 $66,457
1/7/2011 $56,327 $45,269
1/8/2011 $55,429 $75,236
1/9/2011 $63,256
1/10/2011 $95,362
1/11/2011 $42,567
1/12/2011 $23,574
$305,990 $643,100
I want to add 1/1 - 1/8 in 2010 because that is the comparable YTD that I have for 2011. But I'd like to do this via some kind of formula versus summing the corresponding dates in 2010 every time. I have to do this for a wide variety of metrics so it takes too much time, i feel there has to be something more efficient!
Any suggestions?
Last edited: