Google Sheets: summarise monthly data

Question

I have a Google Sheet with two columns:

1. A date in the form dd/mm/yy
2. The number of people who have registered that day

I have a second sheet in the same workbook also with two columns:

1. The month in the form of mmmm yy
2. The number of people who have registered that month

How do I use SUMIF, without creating additional columns, to fill in the monthly column?

Answer 1

The simplest way is to create a pivot table

Reference:

• Create and edit pivot tables