Hi!

I am trying to figure out a formula to search two data sets; I need to find how many clicks in column F match the Group columns AND the string (column E) contains the word in column A.

Can this be done? Any help is greatly appreciated, thanks!!


A B C D E F
WORD GROUP GROUP TEXT CLICKS
word1 Group1 Group1 String 23
word2 Group1 Group2 String 45
word3 Group2 Group1 String 12