LoveByPDF logo

LoveByPDF
EN

Basics · AVERAGE

AVERAGE formula in Excel - the mean of a range

AVERAGE returns the arithmetic mean of the numbers in a range, ignoring blank cells and text.

=AVERAGE(number1, [number2], ...)
Write it for my sheet

Examples

Type this in the Formula StudioFormula
“average of D2:D51”=AVERAGE(D2:D51)
“round the average of D2:D51 to 2 decimals”=ROUND(AVERAGE(D2:D51),2)
“average of this row where value > 0”=AVERAGEIF(D2:H2,">0")

Tips

  • Blank cells are skipped, but zeros are counted - use AVERAGEIF(range,">0") to leave zeros out.

People also search for

  • average formula in excel
  • how to calculate average in excel
  • excel average formula
  • average formula in excel with example
  • averageif formula in excel
  • average without zero in excel
  • mean formula in excel
  • round average in excel
  • average formula in excel in hindi

FAQ

Does AVERAGE count blank cells and zeros?

Blank cells and text are ignored, but zeros are counted. To leave zeros out use =AVERAGEIF(D2:D51,">0").

How do I round an average to 2 decimals?

Wrap it in ROUND: =ROUND(AVERAGE(D2:D51),2). Formatting only changes the display; ROUND changes the value.

Can LoveByPDF write this formula for me?

Yes. Open your Excel file in the Excel Agent's Formula Studio, click a cell and type what you need - e.g. "average of D2:D51" - you get the formula, a preview on your sheet and an explanation, then insert it.

Related formulas