VBA code to return a count in a cell after cross checking three different criteria

Hello. I am trying to disseminate information to the appropriate cell in the grid below based on three attributes Discipline, Source, and Count (View attached picture for visual). For example: C65 should return the number of all the sources that from the discipline BTR and only have the source CAP-1 (should be 6). You're probably wondering "Whats the point for the Count row?" I need the Multiple column for the table to return the number for all the sources that have more than one source. For example: if D56 had CAP-1 AND Lloyds in the cell (delimited by a comma) then G65 would then have 1 in it.

Can someone provide a solution in VBA for this problem? Capture.PNG

the data range is not guarenteed to be the same each time this is run so I cannot reference specific cells or ranges for this. Is the COUNTIFS() function still a viable option?