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])
Bookmarks