Hi

I have column A - may contain "Surgery" or "*FSA"
Column B - contains Scores e.g. 24, 30 etc

I wish to find the mean of column B where Column A contains either "Surgery" or "*FSA"

My formula:-

=AVERAGE(IF(ISNUMBER(MATCH(A2:A10, {"*FSA", "Surgery"}, 0)), B2:B10))

I enter the formula with Ctrl+Shift+Enter

but I get zero as a result {I know there are scores that fit the criteria

what am I misunderstanding?

Thank you