Hi everyone!
I would like to know what is the formula to know the average cost of the last 12 months for each expenses that I have with the current month and that keeps the last 12 months average as the months go by?
To be more precise and for example: now we are in January 2021, I would like to know the average cost from January 2020 to December 2020 for "Assurance auto" (A2 in the "Budget" tab). The amounts of the expenses are in the "Dépenses" tab.
Thanks in advance for your response and let me know if my query is not clear enough. Have a good day/evening!
P.S.Sorry for those who can't read french, the file is in french but the dates are formatted in english and for the cost column, it's pretty much universal . I've modified the average column in english (column C in "Budget" tab) to let you know where I want to put the formula.
Bookmarks