Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Get nth match with INDEX / MATCH in Excel
  • To count total rows in a range in Excel
  • How to use Excel ROWS Function
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Merge tables with VLOOKUP in Excel

Data Analysis Examples

  • Conditional Formatting Icon Sets Examples in Excel
  • Excel Bar Chart
  • Conditional Formatting Data bars Examples in Excel
  • How to add Trendline to a chart in Excel
  • Conditional Formatting Rules in Excel

Data Validation Examples

  • Excel Data validation don’t exceed total
  • Excel Data validation must begin with
  • Excel Data validation require unique number
  • How To Create Drop-down List in Excel
  • Excel Data validation must contain specific text

Average numbers in Excel

by

This tutorial shows how to Average numbers in Excel using the example below;

Formula

=AVERAGE(range)

Explanation

To get the average of a set of numbers, use the AVERAGE function.

Worked Example:   Average numbers ignore zero in Excel

In the example shown, the formula in E5 is:

=AVERAGE(B5:D5)

which is then copied down the table.

How this formula works

AVERAGE is an automatic function in Excel. In most cases, you’ll supply a range of cells to average, and the function will return the result. However, you can also supply individual arguments to the function, in cases where cells are non-adjacent.

Worked Example:   AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Note that AVERAGE automatically ignores blank cells and text, but zero values are included.

Worked Example:   Average last 5 values in columns in Excel

Post navigation

Previous Post:

Average last 5 values in columns in Excel

Next Post:

Average numbers ignore zero in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • Clean and reformat telephone numbers using SUBSTITUTE function in Excel
  • Get position of 2nd 3rd and more instance of character in Excel
  • TEXT function: Description, Usage, Syntax, Examples and Explanation
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Convert time to time zone in Excel
  • TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Pad week numbers with zeros in Excel
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • PRICEMAT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate loan interest in given year in Excel
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest rate for loan in Excel
  • SLN function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles