Free calculator
Average calculator
Get the arithmetic mean of a pasted list, or switch to weighted mode: one value and one weight per line. You see count, sum, and the mean, with an optional row list in simple mode for small lists. The Google Sheets & Excel block below has copy-ready formulas for the same math.
When to use this calculator
Fast check-the-average work before you paste the same idea into a spreadsheet—transparent numbers, not a full statistics app.
- Confirm the arithmetic mean of a list you are about to chart, budget, or compare against a plan.
- Compute a weighted average when each row has a value and a weight (credits, shares, or importance)—same order in both boxes.
- Get count and sum in one pass when you are reconciling a column from Sheets or Excel.
- Need variance or standard deviation? Use the standard deviation tool in the next section and cross-link from the methodology.
Simple (unweighted) mean: add every value and divide by how many there are. Weighted mean: for each value × its weight, add those products, then divide by the sum of the weights (weights do not have to be percentages or add to 100).
Arithmetic (simple) mean
For values x₁ … x_n, the mean is x = (x₁ + ··· + x_n) ÷ n—what most people call the average in everyday language.
Weighted mean
For each row (value, weight), the weighted mean is Σ (w_i × x_i) ÷ Σ w_i. If all weights are 1, you get the same result as the simple mean.
We do not compute geometric or harmonic means, or time-series rolling averages in this v1—those are different questions with different formulas.
For median, mode, and range from one pasted list, use the mean median mode range calculator (same paste pattern).
If you need variance or standard deviation to describe spread around a mean, open the standard deviation calculator instead of duplicating that math here.
Google Sheets & Excel
Google Sheets and Microsoft Excel (English / US-UK function names) use AVERAGE for an unweighted mean and SUMPRODUCT (with SUM) for weighted work. Replace A1:A99 with your range, and in weighted mode keep value and weight in two columns, row for row. If your Excel is not in English, use Formulas → Insert function in Excel to find the same patterns under your language pack’s own function names.
=AVERAGE(A1:A99)Same as sum ÷ count when the range is numeric; ignores empty text cells. Use AVERAGEA if you need to treat text as 0 (rare in finance lists).
=SUM(A1:A99)/COUNT(A1:A99)Handy when you build count and sum in separate helper cells, or you want to see both pieces before taking the ratio.
=SUMPRODUCT(A1:A99,B1:B99)/SUM(B1:B99)Column A = values, B = weights (same row order). This matches Σ(wx) ÷ Σ(w) from this page; weights need not sum to 1.
Frequently asked questions
Are “average” and “mean” the same?
On this page, yes for the simple mode: we use the arithmetic mean (sum ÷ n), which is what most people call the average in everyday English. (Other “averages” like the median or geometric mean are different; we do not compute them here.)
What is the formula for a weighted average?
Multiply each value by its weight, add those products, then divide by the sum of the weights—as shown in the weighted mode. Weights are often points, credits, or importance; they do not have to add to 1 or 100.
When do I use the standard deviation tool instead?
Use the standard deviation calculator when you need variance or standard deviation—how much values deviate from the mean, with sample vs population choices. This page focuses on one or two list averages only.
Do weights have to sum to 1 or 100%?
No. The weighted mean is Σ(wx) ÷ Σ(w). Doubling every weight (same relative importance) does not change the result. Only a zero total weight (or all weights 0) is undefined, which the tool will flag.
What Google Sheets or English Excel function matches the simple mean?
Use AVERAGE(range) for the arithmetic mean, or the explicit =SUM(range)/COUNT(range) if you are building a template with separate subtotals. The copy cards on this page show the pattern; replace the range with your data.
What are the German function names in Excel for average and weighted work?
A common unweighted mean is MITTELWERT. Sums and counts use SUMME and ANZAHL. A weighted pattern is =SUMMENPRODUKT(A1:A10;B1:B10)/SUMME(B1:B10) (semicolon is typical in DE Excel; adjust list separators to your system). Verify names in your Excel build.
What are the French function names in Excel for average and weighted work?
The usual mean is MOYENNE. Sums: SOMME; for weighted: =SOMMEPROD(A1:A10;B1:B10)/SOMME(B1:B10) with the same row order for values and weights—see your function library for the exact list separator in your locale.
How do I paste two columns for weighted mode?
Paste the value column into the values box, then the weight column into the weights box—same row count and order. If you paste two columns at once, split them into the two text areas so the tool can parse each as one number per line.
Do you show median, mode, or other “averages”?
Not on this page. For median, mode, and range from one pasted list, use this site’s Mean median mode range calculator in the tools hub. This page focuses on arithmetic and weighted means with count and sum. For variance or standard deviation, use the Standard deviation calculator linked in the methodology block.
What if I only have one value?
The mean of a single value is that value—sum ÷ 1. Weighted mode with one row is value × weight ÷ weight, which is just the value (when weight is not 0).
Is this professional or academic advice?
No. It is a free, educational tool. For regulated reporting, grading policies, or research design, use your institution’s rules and qualified professionals.