I'm looking for a way to average the numerical numbers in one column, say B, only if the string in column A contains a certain text.
(In column A) (In column B) Hello table . . . 1 Hello desk . . . 2 Bye table . . . 3 Bye desk . . . . 4
So if the criteria to average the numbers is "desk" the answer would be (2+4)/2=3.
What I came up with so far is:
but it returns an error because the SEARCH only takes one input.