I have a challenge for the advanced excel experts in here, so I am trying to get the average of some numbers but I don't want to count on that AVG the numbers that on another cell match a certain text so I am looking for help with a formula kind like "ignoring" the values that match that text on another cell.

Looking for the AVG of those numbers with exception of "6","7,88" since they match the "missed trade" text. (Tried AVERAGEIFS didn't worked)

CodePudding user response：

Try AVERAGEIFS() like-

=AVERAGEIFS(G1:G7,H1:H7,"<>missed trade")