If you used SUMPRODUCT to get the total amount for the month and then divide it by a count of the times that month occurs in your list you'd get the average. Use =COUNTIF(B10:B1000,01) to get the number of Januarys.