Hi All,
I have the following formula that should return the count of any text string in range A5:A8 that is found in column D and any of these words "East" or "South" or "West" are found in column E.
It is returning zero. Attached sample file.
=SUM(COUNTIFS($D:$D,"*"&$A$5:$A$8&"*",$E:$E,{"East";"South";"West"}))
Any idea how to make this formula to work ?
Bookmarks