AVERAGE Excel Function
Compact mode

AVERAGE

Known for Basic Statistical Calculation

Table of content

Basic Classification

  • Function Category 📊
    Primary classification of the Excel function based on its main purpose and usage domain, helps users quickly identify function types
    • Statistical
      AVERAGE belongs to the Statistical category. Excel functions for statistical analysis and calculations

  • Operation Type 🔧
    Fundamental type of operation or action that the Excel function performs on its inputs
    • Calculation
      AVERAGE performs Calculation operations. Excel functions for performing various calculations

    Facts

    • Interesting Fact 💡
      Unique or lesser-known information about the Excel function
      • Most basic statistical function

    • Sarcastic Fact 🤣
      Humorous or ironic observation about the Excel function
      • Making averages average since Excel began

    Usage Information

    Technical Details

    • Input Data Type 📝
      Types of data that the Excel function accepts as input parameters
      • Number
        AVERAGE accepts Number as input data. Excel functions specifically designed for numerical calculations

    • Version Compatibility 💻
      Indicates which Excel versions and platforms the function is compatible with < including Office 365< Excel 2019< 2016< etc.
      • Excel 2019
        AVERAGE is compatible with Excel 2019 Excel functions that work specifically in Excel 2019 version
      • Excel 2016
        AVERAGE is compatible with Excel 2016 Excel functions that work specifically in Excel 2016 version
      • Excel 2013
        AVERAGE is compatible with Excel 2013 Excel functions that work specifically in Excel 2013 version
      • Microsoft 365
        AVERAGE is compatible with Microsoft 365 Excel functions optimized for the latest Microsoft 365 platform
      • Excel Online
        AVERAGE is compatible with Excel Online Excel functions optimized for use in the web-based Excel Online platform

    • Operating System 💾
      Specifies the operating systems where the function can be used < including Windows< macOS< and web platforms
      • Windows
        AVERAGE runs on Windows Excel functions optimized for Windows operating system
      • MacOS
        AVERAGE runs on MacOS Excel functions optimized for MacOS users
      • Web Excel
        AVERAGE runs on Web Excel Excel functions available in web-based versions

    • Required Arguments Count 🔢
      Number of mandatory arguments needed for the function to work properly

    • Required Arguments Type 📊
      The data types accepted as valid input arguments for the function
      • Number
        AVERAGE accepts Number as input types Excel functions that perform calculations specifically with numerical inputs
      • Range
        AVERAGE accepts Range as input types Excel functions that operate on cell ranges for calculations
      • Array
        AVERAGE accepts Array as input types Excel functions that specifically work with array inputs for calculations

    Evaluation

    Alternatives to AVERAGE
    MAX
    Known for Finding Highest Value
    Compare
    MIN
    Known for Finding Lowest Value
    Compare
    COUNT
    Known for Counting Numeric Cells
    📊 is easier to use than AVERAGE
    Compare
    COUNTIF
    Known for Counting With Conditions
    🔢 needs fewer arguments than AVERAGE
    Compare
    SUM
    Known for Basic Arithmetic Calculations
    📊 is easier to use than AVERAGE
    📈 is more versatile than AVERAGE
    🛠 is more reliable than AVERAGE
    ⭐ is rated higher than AVERAGE
    Compare
    COUNTA
    Known for Count Non-Empty Cells
    📊 is easier to use than AVERAGE
    📈 is more versatile than AVERAGE
    🛠 is more reliable than AVERAGE
    ⭐ is rated higher than AVERAGE
    Compare
    PRODUCT
    Known for Multiplying Numbers Together
    Compare
    ROUND
    Known for Round Numbers
    🔢 needs fewer arguments than AVERAGE
    📊 is easier to use than AVERAGE
    📈 is more versatile than AVERAGE
    ⭐ is rated higher than AVERAGE
    Compare
    FACT
    Known for Calculate Factorials
    Compare
    AVERAGEIF
    Known for Conditional Average Calculations
    🔢 needs fewer arguments than AVERAGE
    Compare

    FAQ about AVERAGE