variance

[lucki_87]

how to i calculate the quarterly and annual variance in sales, year over year


month sales
jan 2009 5000
. .
. .
. .
. .
december 2010 9000

variance between first year (jan-09 to dec 09) and second year (jan -10 to dec 10) etc

 

[Robert Mika]

Is your month together with the year in the same cell?
That's mean does it look exactly like"jan2009"