The AVERAGE function calculates the average of numbers provided as arguments. To calculate the average, Excel sums all numeric values and divides by the count of numeric values. This behavior can be replicated with the SUM and COUNT functions like this: = SUM(A1:A5) / COUNT(A1:A5) // manual average calculation
