Calculate every month and year

Is there a reason you have separate tables for 2020 and 2021? The data looks as if it is in the same format. So you might be better off putting it in one table and add a Year column in that table.

Then you can easily use SUMIF or SUMIFS to extract totals by year and month.

SG

You can see what SUMIF and SUMFS do by going to Help > Formulas and Functions Help in your menu and searching for them.

If you put your data in one table then you can easily do exactly the kinds of things you describe.

SG

ryszardb wrote:

It did succeed for each category for each year.

What is "it"? There aren't any formulas visible in your screenshot.

SG

Have you had a look at SUMIF and SUMIFS and considered the "all like data in one table" approach?

SG