AVERAGEIFS with different options for criteria

[Random Stranger]

Hi,
So I have this formula, and it's working correctly but I'm missing one criteria, I want it to look for "SB" or "SBChat" and then average it if it receives the result of either "SB" or "SBChat"
=AVERAGEIFS(E:E,F:F,"SB",$C:$C,$C3)

I can't seem to figure out how.

Thanks!

 

[jasonb75]

You can't use multiple criteria with averageifs on an OR basis, only an AND basis.

If there is nothing else that starts with "sb" in column F then you could use a wildcard, "sb*" (the formula is not case sensitive so it will count "SB" and "sb" with or without wildcards).

If there are other entries starting with "SB" that should not be included then you need to divide sum by count.

=SUM(SUMIFS(E:E,F:F,{"SB","SBChat"},$C:$C,$C3))/SUM(COUNTIFS(F:F,{"SB","SBChat"},$C:$C,$C3))