Averageif help

[Kkajr]

Hi im reposting this question because i think adding responses to my own question caused others to ignore it.

im trying to do an averageif based on if the range contains a certain word, here is how I tried it

=AVERAGEIF(D2:D892, "*"&LEFT(D2:D892,(FIND(",",D2:D892,1)-1))&"*", B2:B892)

But the word it picks is the word on the same row in column D, so if i move the cell up to 5 for example, it would pick the word from d5, move it down to 10, d10.

Any help appreciated, ill have a lot more questions in the coming hours

Sorry its a little broke, next time itll look a lot cleaner, The B column is just filled with 1s or 0s, I also didnt include a similar picture (because of the 4 pic limit) but i showed the m column function at m20, and the output was 3/9

Here is the link to the old question: https://www.mrexcel.com/forum/excel-questions/1041865-averageif-help.html

​

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).