Array Average function

[Gabriela]

Dear all,

I would like to make kindof AVERAGEIFS function, but over an array. My formula is in the following form: (with Ctrl + Shift + Enter of course)
I would like the average to be made over those values in column BM, whose corresponding value in AH is the same as the current row I am filling in the info for (AH2) and the corresponding value in column A not equal to the actual one (A2). And then to copy the formula up to row 5362. I used this

{AVERAGE(IF($AH$2:$AH$5362=AH2;IF(NOT($A$2:$A$5362 =A2);$BM$2:$BM$5362;" ");" "))}



My problem is, that if for let's say the second row values I filter the fields in AH having the same value as AH2 and the same for column A not having the same value as A2, and then compute the average over the filtered data from column BM, I got a different result than using the formula above. The problem is that I would need to use the above formula up to row 5362, so doing it manually does not come into question.

Could you please advise me?

Thank you in advance!