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

Lookup and Reference Examples

  • How to create dynamic named range with OFFSET in Excel
  • Count rows that contain specific values in Excel
  • How to reference named range different sheet in Excel
  • How to use Excel ROWS Function
  • Merge tables with VLOOKUP in Excel

Data Analysis Examples

  • How to Create Column Chart in Excel
  • How to calculate average last N values in a table in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • Add Outline to Data in Excel
  • Create Scatter Chart in Excel

Data Validation Examples

  • Excel Data validation whole percentage only
  • Excel Data validation must contain specific text
  • Excel Data validation allow weekday only
  • Excel Data validation don’t exceed total
  • Excel Data validation exists in list

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:   Sum range with INDEX 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:   Calculate Weighted Average in Excel

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

Worked Example:   3D sum multiple worksheets 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
  • How to extract domain name from URL in Excel
  • SUBSTITUTE function vs REPLACE function in Excel
  • Remove file extension from filename in Excel
  • Split numbers from units of measure in Excel
  • Join first and last name — Manipulating NAMES in Excel
  • Count times in a specific range in Excel
  • DAY function: Description, Usage, Syntax, Examples and Explanation
  • Display the current date and time in Excel
  • Get days between dates ignoring years in Excel
  • Convert Excel time to decimal seconds
  • PV function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate present value of annuity in excel
  • NOMINAL function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate Net Present Value (NPV) in Excel
  • MDURATION function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles