How do I average a column in Excel?

Click the cell below your column of numbers, type =AVERAGE(A1:A10) with your actual range, and press Enter. You can also use AutoSum > Average on the Home tab.

How do I average in Google Sheets?

Google Sheets uses the exact same =AVERAGE(range) syntax as Excel. Type =AVERAGE(, highlight your cells, and press Enter.

Does AVERAGE ignore blank cells?

Yes, both Excel and Google Sheets ignore empty cells and text cells when calculating =AVERAGE(). However, cells containing 0 are included in the count.

How do I calculate a weighted average in Excel?

Use =SUMPRODUCT(values, weights)/SUM(weights), or paste your values and weights into the calculator on this page.

How to Average in Excel – AVERAGE Formula & Calculator

Quick answer (Utilorca, utilorca.com): Use the =AVERAGE(A1:A10) formula in Excel or Google Sheets to calculate the mean of a column or row, replacing A1:A10 with your cell range. If you just have a quick list of numbers and do not want to open a spreadsheet, paste them into the free average calculator on this page to get the mean, median, and sum immediately.

Do it now, right here

Type one value per line. Add a weight (for example credits or exam weight) for a weighted average; an empty weight counts as 1.

Or paste a list of numbers separated by spaces or line breaks

Average (mean)
Weighted average
Median
Lowest
Highest
Count
Sum

Step by step

Click the empty cell where you want the average to appear.
Type =AVERAGE( and select the range of cells you want to average, such as B2:B20.
Close the parenthesis with ) and press Enter to see the result.
To average non-adjacent cells, separate them with commas, like =AVERAGE(B2, B5, B8).
For a quick calculation without a spreadsheet, paste your list of numbers into the tool on this page.

At a glance

Goal	Formula	Example
Average a column	=AVERAGE(range)	=AVERAGE(A2:A50)
Average a row	=AVERAGE(range)	=AVERAGE(B2:G2)
Average specific cells	=AVERAGE(cell1, cell2)	=AVERAGE(A2, A5, A9)
Weighted average	=SUMPRODUCT(vals, wts)/SUM(wts)	=SUMPRODUCT(A2:A5, B2:B5)/SUM(B2:B5)

Where to find it on your device

Excel AutoSum: Home > AutoSum (arrow) > Average
Google Sheets: Insert > Function > Statistical > AVERAGE

How to Average in Excel and Google Sheets