average small if 5 or 10 values ignoring blank cells

[rexysri]

i am using this formula =AVERAGE(LARGE(IF('Stu List'!$F$3:$F$1322=$E$1,'Stu List'!$K$3:$K$1322),ROW(1:5))) for Average large 5 and 10 values it's working, but when i am trying to average small 5 values ignoring blank cells its not working AVERAGE(SMALL(IF('Stu List'!$F$3:$F$1322=$E$1,'Stu List'!$K$3:$K$1322),ROW(1:5)))

CAN ANY ONE HELP..

 

[Momentman]

There definitely would be "cleaner" ways to address this, but see if this modification works for you

AVERAGE(SMALL(IF('Stu List'!$F$3:$F$1322=$E$1,IF('Stu List'!$F$3:$F$1322<>"",'Stu List'!$K$3:$K$1322)),ROW(1:5)))

 

[rexysri]

There definitely would be "cleaner" ways to address this, but see if this modification works for you

AVERAGE(SMALL(IF('Stu List'!$F$3:$F$1322=$E$1,IF('Stu List'!$F$3:$F$1322<>"",'Stu List'!$K$3:$K$1322)),ROW(1:5)))

Thank you so much brother... trying this formula since a week..

 

[Momentman]

Thank you so much brother... trying this formula since a week..

You are welcome. Glad to help