Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate churn rate in Excel and Google Sheets
Topic:SaaS metricsExcel & Google Sheets
=COUNTA(B2:B4)/COUNTA(A2:A4)-1✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Starting Customers | Ending Customers |
| 100 | 90 |
| 150 | 130 |
| 200 | 180 |
=COUNTA(B2:B4)/COUNTA(A2:A4)-1→0
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your starting customer count in column A and ending customer count in column B.
- 2In an empty cell, input the formula to calculate churn rate.
- 3Press Enter to see the churn rate as a decimal.
Tips
- Ensure your data range matches the formula's references to avoid errors.
- Format the result as a percentage for easier interpretation.
- Check for any discrepancies in your data entry to ensure accuracy.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What does a negative churn rate mean?
A negative churn rate indicates an increase in customers over the period.
Can I use this formula for monthly churn rates?
Yes, adjust the data to reflect the start and end of the month.
How do I handle zero starting customers?
Avoid division by zero by ensuring there are initial customers or adjusting the formula logic.
More on SaaS metrics
See all →Reference
RANDARRAY
Spills a grid of random numbers with specified rows, columns, min, max, and integer/decimal options. Excel 365 and Google Sheets only.
How-toHow to calculate churn rate
Calculate monthly or annual customer churn rate as lost customers divided by starting customers, expressed as a percentage, in Excel and Google Sheets.
Error fixFix #####
Fix ##### in Excel — the column is too narrow to display the number or date. Widen the column or change the format to resolve it.
ReferenceARRAYTOTEXT
Converts an array or range into a single text string, with concise or strict formatting options.
How-toHow to calculate monthly recurring revenue (MRR)
Learn how to calculate MRR in Excel and Google Sheets using SUMIF to sum active subscription revenue by billing period, normalized to a monthly figure.
Error fixFix Array result
Array result was not expanded in Google Sheets means output cells are blocked. Clear adjacent cells or use a blank area.