How to calculate total per month?

Hi ryszardb,

Add another column to each year table to show the month name.

You can hide the extra column (B) later.

My Region (Australia) does not allow a Date format as 1-1-2017.

I used 1 Jan 2017, but it works!

=MONTHNAME(MONTH($A2))

In German,

=MONATSNAME(MONAT($A2))

For 2017,

=SUMIF(2017::B,$A2,2017::C)

In German,

=SUMMEWENN(2017::B;$A2;2017::C)

For 2018,

=SUMIF(2018::B,$A2,2018::C)

In German,

=SUMMEWENN(2018::B;$A2;2018::C)

In Table 1, the month names are Text ('January) and they work in English and German. The charm of Numbers!

Tested in Numbers 5.2 under macOS High Sierra 10.13.6

Regards,

Ian.