Sum or Average based on multiple cell criteria

Dear All,

I have bunch of data that I want Summary based on kriteria in horizontal and vertical.
I forgot wich formula I had to use,

=+AVERAGEIFS($B$526:$MH$729;$B$525:$MH$525;ML525;$A$526:$A$729;MJ526)

I already attach the example,

Cell BM100 formula

Formula:

=AVERAGE(IF(($B$99:$BI$99=BM$99)*($A$100:$A$135=$BK100)*($B$100:$BI$135>0),$B$100:$BI$135))

Originally Posted by Sultan1994

Dear All,

I have bunch of data that I want Summary based on kriteria in horizontal and vertical.
I forgot wich formula I had to use,

=+AVERAGEIFS($B$526:$MH$729;$B$525:$MH$525;ML525;$A$526:$A$729;MJ526)

I already attach the example,

Its says #VALUE!

Please refer to this attachment, specially painted light green areas

Oh I see,,

I forgot to put array in it.
Thank you very much mate,,

@Sultan1994 You're Welcome. Glad to help . Thank You for the feedback and rep.