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?

CodePudding user response：

The simpliest way is to create a pivot table