how to calculate the average difference in excel?
Explanation: Sum function gets the sum of D4 to D13 and C4 to C13. Then we took the difference between the two. To get the Average difference we will divide it by total number of values using the COUNT function.