Summing Multiple Rows with Criterion

[AliGW]

I'm looking for another push in the right direction, please!

I have two tables in columns B to K and M to P:

Excel 2016 (Windows) 32 bit

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3	Department	Staff	KS3	KS4	KS5	Games	Compass	RHS+	EPQ	Other		Staff	Total	Allocation	+/-
4	MFL	AGW	10	7	6				6			AGW	29	31
5		JER
6		NJM
7		RGE
8		AGW	1
9		SMG
10		MCJ
11		TP
12		FLA Fr
13		FLA Gm
14		FLA Sp

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	N
4	=SUM(VLOOKUP(M4, $C$4:$K$14, {2,3,4,5,6,7,8,9}, FALSE))

Sheet: Sheet1

I had hoped that the formula in N4 would allow me to sum any row where my initials (AGW) occur in column C, but it doesn't work as I had hoped. The correct answer in N4 is 30, but it's returning 29, so it's only summing the first row where my initials occur. Could some kind soul tell me what to tweak to make it do what I'd like it to?

[Glenn Kennedy]

Try:

=SUMPRODUCT(($B$3:$B$13=L3)*$C$3:$J$13)

[AliGW]

That's the one, Glenn - thanks!