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 :


		                 Criteria 1	Criteria 2	Criteria 3	Criteria 4	Criteria 5
Item 1	Criteria A	   42 	          13 	             30 	 35 	          16 
Item 2	Criteria B	   14 	          50 	             45 	 27 	          45 
Item 3	Criteria C	   19 	          45 	             15 	 18 	          41 
Item 4	Criteria D	   27 	          33 	             12 	 45 	          24 
Item 5	Criteria A	   6	          54	             23	         18	          40
Item 6	Criteria A	   47	          42	           45	         10	          25
Item 7	Criteria C	   9	          43	           15	         21	          50
Item 8	Criteria C	   43	          2	           47	         25	          52
Item 9	Criteria D	   2	         16	           30	         48	          23
to get a result in this manner



	         Criteria A	Criteria B	Criteria C	Criteria D
Criteria 1	          95 	        14 	        71 	       29
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.