Average Calculator
Calculate average, sum, count, minimum, and maximum.
● Processed locally in your browser unless the page says otherwise.
Note
When average is useful
An average summarizes a group of numbers with one representative value. It is useful for grades, spending, sales, work hours, survey scores, and many other datasets. This calculator also reports sum, count, minimum, and maximum for quick review.
Be careful with outliers. A very large or very small value can pull the average up or down, so it may be useful to also check the median or the data range.
Formula or logic
- Average = Sum of all values ÷ Number of values
Example
If sales over three days are 80, 100, and 120, the sum is 300 and the average is 100 per day. If one day is 1,000, the average rises sharply and should be investigated.
Common questions
How is average different from median?
Average is total divided by count. Median is the middle value after sorting. Median is less affected by outliers.
Are blanks or text included?
Only valid numbers should be included. Blank cells, text, or malformed data should be cleaned first.
Can an average represent the whole dataset?
It is a useful summary, but if the data is uneven, also check minimum, maximum, median, or distribution.