Find and Total a range of cells

[George T]

I am trying to get this formula to find a match in coulmn C And Total all data in columns D,E,F,G,H from cell 13 thur 33. Then I want to divide that sum by cell I9 in order to get a percentage. This is my formula below:

=IF($J15=0,"",SUMIF($C$13:$H$35,J15,$D$13:H33))

 

[jbeaucaire]

Maybe like so:

Excel Workbook
	C	D	E	F	G	H	I	J	K	L
13	1	2	3	4	5	6
14	2	2	3	4	5	6
15	3	2	3	4	5	6		5		100
16	4	2	3	4	5	6
17	5	2	3	4	5	6
18	1	2	3	4	5	6
19	2	2	3	4	5	6
20	3	2	3	4	5	6
21	4	2	3	4	5	6
22	5	2	3	4	5	6
23	1	2	3	4	5	6
24	2	2	3	4	5	6
25	3	2	3	4	5	6
26	4	2	3	4	5	6
27	5	2	3	4	5	6
28	1	2	3	4	5	6
29	2	2	3	4	5	6
30	3	2	3	4	5	6
31	4	2	3	4	5	6
32	5	2	3	4	5	6
33	4	2	3	4	5	6
34	3	2	3	4	5	6
35	5	2	3	4	5	6
Sheet3