Hi All,

I am trying to do a sum of multiple criteria, something like an array. I tried the "SUM(INDEX(D2:H12,0,MATCH(A3,D1:H1,0)))" but it will only select the criteria horizontally.

My data :

Please Login or Register  to view this content.
to get a result in this manner


Please Login or Register  to view this content.
I have massive line item data so the reason im doing it this way is to find a smart wat categorizing this using any given condition.

Thanks in advance.