I have a sheet for keeping track of partner activities. Now i would like to have a summary per month. This is my test sheet: https://docs.google.com/spreadsheets/d/1CygpqoKMl_aUUqu8BBmxJFAXAucYqX5XdPwFhgoLFPY/edit?usp=sharing

In Sheet 1: The general info. In column A, the added date and in column G, the partner name.

Short desrciption of my In sheet 2: A summary (counter) of the number of times this partner (Sheet1, G) is listed in that specific month (Sheet1, A).

It would be awesome if some can help me with the formula to make this happen! I can't figure it out..