I'm trying to count the number of cells in column B (B1:B8) that contain one of a couple of words from a list (C1:C3), not occurances. Also, I only want the cells counted if the dates next to them in column A are older than Today()-60. The cells in column B sometimes contain more than one word from the list. I have my formula in C5 and what I've come up with is =COUNTIFS(A1:A8,"<"&TODAY()-60,B1:B8,{"*RED*","*WHITE*","*BLUE*"}), but it's only counting occurances of "*RED*". It counts 1, but I need it to count 3. I'm stuck. I'd like to do this without using a hidden column or cells. Thanks in advance.
Excel 2016 (Mac) 64 bit
[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]
[tr=bgcolor:#FFFFFF][td]
[tr=bgcolor:#FFFFFF][td]
[tr=bgcolor:#FFFFFF][td]
[tr=bgcolor:#FFFFFF][td]
[tr=bgcolor:#FFFFFF][td]
[tr=bgcolor:#FFFFFF][td]
[tr=bgcolor:#FFFFFF][td]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]
Excel 2016 (Mac) 64 bit
[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]
8/1/17
[/td][td]RED, BLUE[/td][td]RED[/td][/tr][tr=bgcolor:#FFFFFF][td]
8/1/17
[/td][td]RED, WHITE[/td][td]WHITE[/td][/tr][tr=bgcolor:#FFFFFF][td]
8/1/17
[/td][td]BLUE, WHITE[/td][td]BLUE[/td][/tr][tr=bgcolor:#FFFFFF][td]
8/1/17
[/td][td]YELLOW[/td][td][/td][/tr][tr=bgcolor:#FFFFFF][td]
4/1/17
[/td][td]YELLOW[/td][td][/td][/tr][tr=bgcolor:#FFFFFF][td]
4/1/17
[/td][td]BLUE[/td][td][/td][/tr][tr=bgcolor:#FFFFFF][td]
4/1/17
[/td][td]WHITE, RED[/td][td][/td][/tr][tr=bgcolor:#FFFFFF][td]
4/1/17
[/td][td]YELLOW, WHITE[/td][td][/td][/tr][/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]