Count multiple rows (text) with multiple criteria (text)

Hi there!

Hereīs the thing: I have a table/worksheet (DataTable) where I track every business opp that our salesmen insert in our crm. One of the columns of this table, named "source code" holds the name of the event that generated the business lead. I.e: "breakfast at hilton hotel". There are multiple rows that in this column hold this value, as well as others hold others. (I will attach an example, sorry if Iīm not clear enough).

Hereīs the thing: in another worksheet (SourceCodes)I have another table holding the entire list of available source codes, by event type. This means that each source code is related to one specific event type. I.e: social events, launchs, etc.

Now, there is yet another worksheet (Stats) where my table is empty and here is my problem. I need to count rows in my first worksheet/table and determine, matching them to the data in the second sheet (validating data) grouping them by event type.

So, basically in this last table I need to see for example how many social events we hosted, (i donīt need the detail on how many breakfasts, cocktails and such we did, but the sum of all of them).

What formula should I try? SUM, SUMIF, DCOUNTA and such havenīt been of much help up to now...

Thanks!!!

Ale