I am looking for a formula like below, but after it has filtered that far, is there a way to make it count each entry in A2:A99999 only one time so it ignores all the second and third entries of the same values in that cell range.

=COUNTIFS('ROOM 2'!C2:C999999,"NETWORK",'ROOM 2'!D2:D999999,"5A*")