Hi

I am working out some averages (Mean, Mode, Median) for a large data set.

For mean I have used AVERAGEIFS as I have some criteria I want to check against.

Now I want to do the same for Mode and Median but I don't see the *IFS* functionality in Excel. Is there a way round this could I create some sort of compound formula something like (mode(IFS(A:A,"x",B:B,"y")).

thanks in advance

Robin