How to Use AVERAGE Function in Excel

About this video

• Video Title: How to Use AVERAGE Function in Excel
• Channel: Excel 10 tutorial
• Speakers: (None specified in the transcript)
• Duration: 00:04:32

Overview

This video explains how to use the AVERAGE function in Microsoft Excel. It demonstrates how to input the function, explains its parameters, and clarifies how it handles different types of cell entries like numbers, empty cells, zeros, and text. The video also shows a manual calculation to verify the function's accuracy.

Key takeaways

• Function Syntax: The AVERAGE function is initiated by typing =AVERAGE( followed by the data range or numbers to be averaged.
• Parameter Handling: The function primarily takes numbers as arguments, which can be directly entered, or more commonly, a range of cells. Up to 255 numbers or ranges can be included using commas as separators.
• Data Type Exclusion: The AVERAGE function does not count text or empty cells within the selected range when calculating the average.
• Zero Values: If a cell contains a zero, it is considered a value and is included in the average calculation.
• Manual Verification: The video illustrates how to manually calculate the average by summing the numbers and dividing by the count of valid entries, confirming the AVERAGE function's output.