Count Multiple values occurring in other range

I have a Table Color_List[Colors] of multiple values (Blue & Green).

I would like to get a total count of these values if they occur in another table [RawColors] AND if another criteria is met (Status is Active).

Below formula did not work:

COUNTIFS(RawColors[Status], "Active", RawColors[Colors], Color_List[Colors])

J3=SUMPRODUCT(COUNTIFS(RawColors[Colors],Color_List[Colors],RawColors[Status],"Active"))

Just wrap it in sum

Formula:

Please Login or Register  to view this content.