Poradnik Excela

How to Calculate an Average in Excel

Calculating the average is a fundamental task in Excel. This guide covers both simple averages and conditional averages based on specific criteria.

Krok po kroku

1
Calculate a simple average
Select the cell where you want the result, type '=AVERAGE(range)', and press Enter.
2
Calculate an average with criteria
Type '=AVERAGEIF(range, criteria, [average_range])' to calculate the average of cells that meet a specific condition.
3
Verify your results
Highlight the range of cells and check the status bar at the bottom right of the Excel window to see the automatic average calculation.

=AVERAGE(A1:A10) or =AVERAGEIF(A1:A10, ">50")

The AVERAGE function ignores empty cells and text, but includes cells with a value of zero.
Use AVERAGEIFS if you need to calculate an average based on multiple criteria.

Does the AVERAGE function include hidden rows?

Yes, the standard AVERAGE function includes data in hidden rows. Use SUBTOTAL(1, range) if you want to ignore them.