You can use the following formula in Excel to calculate the sales growth between two different periods:
This formula calculates the sales growth, assuming the value in cell B2 represents the value for the first sales period and the value in cell B3 represents the value for the second sales period.
The following example shows how to use this formula in practice.
Example: How to Calculate Sales Growth in Excel
Suppose we have the following dataset that shows the total sales made by some company during 10 consecutive years:
Suppose we would like to calculate the sales growth for each year.
To do so, we can type the following formula into cell C3:
We can then click and drag this formula down to each remaining cell in column C:
Next, we can display the sales growth values as percentages by highlighting the cell range C3:C11, then clicking Percentage from the Number Format dropdown menu in the Number group on the Home tab:
Each of the sales growth values will now be displayed as percentages:
From the output we can see:
- Sales grew by 11.54% from 2010 to 2011.
- Sales grew by 31.03% from 2011 to 2012.
- Sales declined by 5.26% from 2012 to 2013.
And so on.
If you’d like to visualize these values, you can highlight the cell range C3:C11, then click the Insert tab along the top ribbon, then click the icon titled Cluster Column within the Charts group:
The following bar chart will appear that displays the sales growth values by year:
This allows us to quickly see which years had positive vs. negative sales growth.
The following tutorials explain how to perform other common operations in Excel: