I'm trying to find the average of a column where two conditions are met by using the AVERAGEIFS() function. One of these conditions is that the cell within the 'criteria' range NOT contain a substring. In the example file I've included I want the average of the Value column, but only including rows where the 'Key' doesn't contain the letter b and 'Level' is 1. I tried to do this using the function:
=AVERAGEIFS(A2:A32,B2:B32,<>"*b*",C2:C32,1)
This gives an error because I believe <> is expecting a numeric value and I give it string criteria. Is it possible to get this to work using AVERAGEIFS or another method?
Thanks.
Bookmarks