Sales growth rate formula in Excel or Google Sheets
Put the inputs in column B from row 2, then paste the formulas below. They work the same in Excel and Google Sheets.
| Cell | What | Value or formula | Example |
|---|---|---|---|
| B2 | Revenue previous period ($) | 400000 | 400000 |
| B3 | Revenue this period ($) | 460000 | 460000 |
| B5 | Sales growth (%) | =ROUND((B3-B2)/B2*100,1) | 15 |
| B6 | Change ($) | =B3-B2 | 60000 |
Get the ready-made spreadsheet
The same calculator as an .xlsx file, with the formulas set up. Free: enter your email and the download starts here right away. Your email also joins Clarivoxx Insights (a weekly article and a monthly newsletter; unsubscribe in one click).
Frequently asked questions
- How do you calculate sales growth?
- Subtract last period's revenue from this period's and divide by last period's. $400,000 to $460,000 is 15% growth.
- Month over month or year over year?
- Year over year removes seasonality and is better for reporting. Month over month is useful for early-stage companies that change quickly.
- How do I compare growth over several years?
- Use the compound annual growth rate: (end ÷ start)^(1 ÷ years) − 1. It gives one yearly rate that leads from the first value to the last.
About the author
Abdessamad Ghanem
Customer Experience & Customer Success Consultant · Founder of Clarivoxx
Abdessamad Ghanem works across Customer Support, Sales, Customer Success, Account Management and Partner Management. He writes Clarivoxx Insights for B2B SaaS professionals who own retention, adoption and customer outcomes.