Count cells, not occurances, with multiple criteria

[SpadeEXE]

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]

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]

 

[SpadeEXE]

One more time

Array formula
=SUM(IF(A1:A8 < TODAY()-60,IF(MMULT(--ISNUMBER(SEARCH(TRANSPOSE(C1:C3),B1:B8)),ROW(C1:C3)^0)>0,1)))
Ctrl + Shift+ Enter

Mac: Shift+CMD+Enter (not sure)

Can you see the whole formula now?

M.

Sorry, I'm viewing this on a phone, but IT WORKS!!! Holy cow thanks. This has been stumping me for a while.

 

[Marcelo Branco]

You are welcome. Glad to help

M.

 

[Aladin Akyurek]

Correct, but I want to count how many cells contain either RED, WHITE, or BLUE, and is older than 60 days, not just RED. So it should count A6, A7 once (counting cells, not occurances), and A8. Thanks.

Right. That requires MMULT indeed...