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,

Please Login or Register  to view this content.

I already attach the example,

Cell BM100 formula

Formula:

Please Login or Register  to view this content.

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,

Please Login or Register  to view this content.

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.