Average Ifs

[jamescooper]

Hello,
I have the following formula which takes the average of the first 5 values of a column, how would I add in so it ensures column A2:A5000 = 1, or 2, or 3, too?

=AVERAGE(IF(ROW(P2:P5000<=SMALL(IF(P2:P5000<>"",ROW(P2:P5000)),MIN(COUNT(P2:P5000),5)),IF(P2:P5000<>"",P2:P5000)))

Many thanks.

 

[jamescooper]

Any ideas here please?

Thanks.

 

[Aladin Akyurek]

Control+shuft+enter:

1.

=AVERAGE(IF(ROW(P2:P5000)<=SMALL(IF(ISNUMBER(P2:P5000),ROW(P2:P5000)),MIN(COUNT(P2:P5000),5)),IF(ISNUMBER(P2:P5000),P2:P5000)))

2.

=AVERAGE(IF(ROW(P2:P5000)<=SMALL(IF(ISNUMBER(P2:P5000),IF(A2:A5000=1,ROW(P2:P5000))),MIN(SUM(IF(A2:A5000=1,IF(ISNUMBER(P2:P5000),1))),5)),IF(A2:A5000=1,IF(ISNUMBER(P2:P5000),P2:P5000))))