I'm trying to create a report to count the number of events based on a few conditions. This is the formula I've came up with so far:

=SUM(COUNTIFS('Sheet1'!B:B,"202204",'Sheet1'!M:M,{"This is text 1","This is text 2","This is text 3","This is text 4"}))

The formula above works well counting the total number of events but it doesn't remove the duplicates.

The first condition is to select the period 202204 and then match the events with the text description. Each event has a unique number but it comes with various asset numbers in the next column in Sheet1 that I don't need for the report I'm creating. The reason why I only need to know/count the total number of events for each month based on the period and description.

This report is pulling data from another tab which is importing filtered data from a different spreadsheet (image below). The final goal here is to allow my team to simply click Refresh All data to automatically update the report.

The data in this spreadsheet has been edited for privacy reasons and the dataset is a lot bigger than what I'm showing.