Add another criteria

=AVERAGE(IF(B:B=I6,IF(IF(B:B=I6,ROW(B:B),"")>=LARGE(IF(B:B=I6,ROW(B:B),""),H5),C:C,""),""))

Say I have this formula already lined up, how would I add another criteria (If I want C:C=H6 to be added) in here?

Thanks in advance.

bumpbumpbump

Not sure what the formula is doing as there appears to be (to me!) extraneous IFs.

I agree with John, it's hard to decipher what the formula is doing...
But if I had to guess, try

=AVERAGE(IF(C:C=H6,IF(B:B=I6,IF(IF(B:B=I6,ROW(B:B),"")>=LARGE(IF(B:B=I6,ROW(B:B),""),H5),C:C,""),"")))

I also recommend NOT using entire column references like C:C, limit it to the actual used area like C$2:C$100


And if that's not it, you'll have better luck if you just explain in words what the formula is supposed to do.
Maybe attach a sample book

Originally Posted by Jonmo1

I agree with John, it's hard to decipher what the formula is doing...
But if I had to guess, try

=AVERAGE(IF(C:C=H6,IF(B:B=I6,IF(IF(B:B=I6,ROW(B:B),"")>=LARGE(IF(B:B=I6,ROW(B:B),""),H5),C:C,""),"")))

I also recommend NOT using entire column references like C:C, limit it to the actual used area like C$2:C$100


And if that's not it, you'll have better luck if you just explain in words what the formula is supposed to do.
Maybe attach a sample book

Originally Posted by JohnTopley

Not sure what the formula is doing as there appears to be (to me!) extraneous IFs.

Sample.xlsx

Does this work?

Basically for Team A, I want to see the last 5 and 10 averages for them on the road and home.
That was why I needed the average if function. Thanks in advance.

bump
bumpbump

still need help.

Need help with an average formula.