Forum Discussion
What's wrong with my Average IF formula?
hi everyone, I wonder if you can help me with a question I have; I want to use the word in Column A to search another sheet - every time it finds a particular word in a sentence (column B) ...
SOLVED: FOR THOSE LOOKING FOR A SIMILAR SOLUTION THIS IS WHAT I HAVE' =AVERAGEIF(SHEETNAME!RANGE:RANGE,"*"&REFERENCE CELL&"*",SHEETNAME!RANGE:RANGE)