Hello I have date, value, and category columns. I need to create a formula where I sum the values for every month for each category in the data set . I then need an average of all these months for the given year (or period), separated by category, which will be the category used in the actual chart. As an example lets say I have spending and income as my categories. I first need to calculate total spending by month, and total income by month. I then need to average those totals for spending and income such that the result indicate my average total spending and and income for by month. The formula likely is not very complicated but its confusing to explain. Thanks for the help!

Tobias