Average with mutiple strings as criteria

[vshankaa]

I want to use AVERAGEIF with multiple string criterias.

Example for normal AVERAGEIF >> AVERAGEIF(A1:A1000,B1,C1:C1000) << Where A1:A1000 is the criteria range, B1 is the criteria, and C1:C1000 is average range.

I want to use it this way >> AVERAGEIF(A1:A1000,B1:B5,C1:C1000) << Where A1:A1000 is the criteria range, B1:B5 is the criteria (multiple string values), and C1:C1000 is average range.

Is the above possible? AVERAGEIFS has a limitation with the number of criterias that can be give.