Average by Month: How to Calculate It

This calculator works out the average of a set of numbers that are grouped by month, giving you a single per-month figure. You enter the monthly totals (or any values) and the number of months, and it returns the arithmetic mean. The result is the sum of all monthly values divided by how many months you included.

Formula

The average per month is the simplest form of the arithmetic mean:

Average = Total ÷ Number of Months

Where:

• Total – the sum of all monthly values (same unit as your data, e.g., dollars, items, kWh).
• Number of Months – the count of months in the period (a whole number, typically 1–12 for a year, but can be any positive integer).

This formula assumes each month is given equal weight. It does not account for months having different lengths (28 vs. 31 days). If you need a daily average, divide the total by the actual number of days in the period instead.

Worked Example

Using the defaults from the calculator: total = 1200, months = 6.

1. Write down the formula: Average = Total ÷ Months
2. Plug in the numbers: Average = 1200 ÷ 6
3. Divide: 1200 ÷ 6 = 200

The average per month is 200. The calculator shows 200.00 with two decimal places, which matches.

When to Use This Average

This calculation is useful any time you have monthly totals and want a single representative figure. Common examples include:

• Monthly sales or revenue over a quarter or year
• Monthly utility bills (electricity, water, gas) to budget for an average month
• Monthly website visitors or social media engagement
• Monthly expenses or savings contributions
• Monthly production output or inventory usage

The result gives you a baseline for comparison: you can compare any single month against the average to see if it was above or below typical performance. It also helps with forecasting, but remember that averages hide variation—a month that is 50% above average and another that is 50% below will still produce a “typical� average that doesn’t reflect either extreme.

How to Read the Result

The average per month is in the same unit as your input total. If you entered dollars, the result is dollars per month. If you entered kilograms, it’s kilograms per month. The calculator does not convert units, so be consistent.

One common misinterpretation: the average is not the “typical� month if your data has a strong trend or seasonality. For example, if sales grow steadily from 100 to 600 over six months, the average is 350, but no single month was close to that. In such cases, a trend line or median might be more informative.

Also note that this average treats all months equally. February (28 days) gets the same weight as March (31 days). If your data is daily and you want a true daily average, divide the total by the number of days, not the number of months.

Common Mistakes and How to Avoid Them

• Using the wrong number of months: If you have data for January through June, that’s 6 months, not 5. Double-check your count.
• Mixing units: Ensure all monthly values are in the same unit. Don’t add dollars and thousands of dollars together.
• Rounding too early: If you round each monthly value before summing, you introduce error. Sum the exact values first, then divide, then round the final answer.
• Forgetting missing months: If you have no data for a month, decide whether to exclude it (and reduce the count) or include it as zero. Including a zero will lower the average. Be explicit about which you did.

Limitations of the Simple Average

The arithmetic mean is sensitive to outliers. One extremely high or low month can skew the average significantly. For example, if five months are 100 each and one month is 1000, the average is (5×100 + 1000) ÷ 6 = 250, which is more than double the typical month. In such cases, the median (the middle value when sorted) might be a better measure of central tendency.

This average also assumes a linear relationship—that each month contributes equally. If you are analyzing growth rates, a compound average (geometric mean) would be more appropriate, but that requires a different formula.

Finally, the simple average gives no insight into variability. Two datasets can have the same average but completely different distributions: one might be stable around 100, another might alternate between 0 and 200. Always look at the range or standard deviation alongside the average to understand the full picture.

Alternatives to the Simple Average

Depending on your goal, one of these may serve better:

• Median: The middle value when months are sorted. Resistant to outliers.
• Weighted average: Assign different weights to months (e.g., by number of days) to account for unequal month lengths.
• Moving average: Averages over a rolling window (e.g., 3-month) to smooth out short-term fluctuations and reveal trends.
• Compound annual growth rate (CAGR): For growth over time, this gives the annualized rate, not a simple average of monthly values.

For most straightforward “what is the typical monthly value� questions, the simple average is fine. Just be aware of its blind spots.

Frequently Asked Questions

How do I calculate the average monthly balance for a bank account?

Banks typically use the daily balance method: sum the balance at the end of each day in the month, then divide by the number of days in that month. That gives a daily average, not a monthly average. If you only have monthly closing balances, the simple average of those monthly figures is a rough approximation but not the same as the daily average.

What if I have 13 months of data, can I still use this calculator?

Yes, the number of months can be any positive integer. Just enter the total for all 13 months and set the months field to 13. The result will be the average per month across that period.

Should I include months with zero value?

It depends on what you are measuring. If a zero is a real observation (e.g., no sales in a closed month), include it. If the month is missing because of a data collection gap, you might exclude it and reduce the count. Be consistent and document your choice.

How is this different from a year-to-date average?

A year-to-date average is simply the average from January up to the current month. It uses the same formula but only includes the months that have elapsed. For example, if it’s June, you average January through May or June, depending on whether the current month is complete.

Can I use this for daily averages?

Not directly. This calculator divides by months. To get a daily average, divide the total by the number of days in the period (e.g., 365 for a year). If you have monthly totals and want a daily average, you could multiply each month’s average by 12 and divide by 365, but that’s an approximation because months have different lengths.

Why is my average different from what my spreadsheet gives?

Check whether your spreadsheet is using the same formula. If you used AVERAGE on a range of monthly values, it sums and divides by the count—same as here. If you used AVERAGE on a range that includes empty cells, those are ignored, which may change the result. Also, ensure you didn’t accidentally include a total row in the range.

Related

• Galaxy S9 Loses Service: Fixes That Work
• Crimson Desert Character Creation Explained
• Coffee Seed Labels: Why They’re Wrong & DNA Testing

in t | Total value | - | 1200 | 0
in n | Number of months | months | 6 | 1
out avg | Average per month | - | t / n | 2