I have attached your file with my formula included.
As I said before, to calc, for instance, an annual average "spend", you need to sum the "spend" for all the months divided by the sum of the all the occurrences for all the months. You cannot calc an average for the year by averaging the monthly averages
Bookmarks