Average in multiple month

[Luigi802]

How can I average the total amount I spent on 1 item, but only the months that I spent money on it, for example, Let's say I spend 100 on clothes in jan, 35 in March, 62 in April, 50 in August......and so on I want to only average the amount I spent in the months I spent it. Like right now we are in December, if I just take the total divided by the total amount of months I'd be dividing by 12, when I only want to divide by 4 because I only bought clothes 4 out of the 12 months.........does that make sense?

 

[Scott Huish]

How is your data set up? Do you have months across the top and categories on the left or dates or what?

 

[Luigi802]

How is your data set up? Do you have months across the top and categories on the left or dates or what?

Column 1 are the dates, column 2 are the amounts and column 3 are the categories