Sum formula that uses criteria from columns as well as rows

[fsuguy92]

[FONT=&quot]Hey guys, I need a formula that will sum data based on rows and columns. For instance - see my image attached.[/FONT]
[FONT=&quot]What I need is to lookup "NFLApparel" in column A and then sum up all of the values that correspond with row 40 = 1.[/FONT]
[FONT=&quot]So in this instance it would sum cells J50 and K50.[/FONT]
[FONT=&quot]I've tried sumproduct and some other formulas that I can't seem to get to work... thanks for your help!

[/FONT]

 

[sheetspread]

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
2			1			1				1				1
3	NFLApparel	87	72	59	50	18	30	85	88	92	24	33	30	91
4	q	39	18	28	19	93	29	39	10	76	59	81	36	50
5	w	69	24	89	16	82	25	30	23	16	84	66	10	38
6	e	66	100	50	55	47	81	7	20	58	63	62	21	29
7	r	47	20	70	70	99	100	33	11	92	38	51	90	67
8	NFLApparel	52	93	3	9	51	43	17	86	94	46	10	77	66
9	t	47	83	82	86	39	58	100	46	45	68	69	23	94
10	y	10	11	91	68	8	43	32	59	88	93	94	56	6
11	u	55	28	89	19	53	38	60	42	92	26	73	28	95
12	i	86	41	65	32	41	3	99	79	76	52	40	13	94
13	o	50	63	69	14	38	41	62	3	53	64	74	94	34
14	NFLApparel	72	13	67	77	37	98	78	50	80	7	10	3	38
15	NFLApparel	83	68	16	69	24	94	72	39	99	28	71	64	11
16	p	68	52	96	16	15	9	53	98	8	25	83	17	85
17
18
19		947
20
21		947
Sheet2

Cell Formulas
Range	Formula
B19	=SUMPRODUCT(($A$3:$A$16=A3)*($B$2:$N$2=1)*$B$3:$N$16)
B21	=C3+F3+J3+N3+C8+F8+J8+N8+C14+F14+J14+N14+C15+F15+J15+N15