Repeating SUMIF Non Continuous Range + Column Match

[Thedude1234]

Hello! I have quite a large series of data that repeats in the format below for ~1000 rows. I want to create a formula that returns sum of all range sets where the column equal to ADMIN and the row equal to WAGE. So with the table below the sum should be (100+4+9)=113. I have been trying it with =SUMPRODUCT((MOD(ROW($B$1:$B$13),5)=2),($B$1:$B$13)) to return the sum of a column on every nth row, however I don't know how to incorporate finding the ADMIN column and then returning the nth row value and then repeating that for 1000 rows. Hopefully this makes sense and thank you!

	ADMIN	SICK	WORK
	3	4	6
	2	1	4
WAGE	100	1	3
	WORK	SICK	ADMIN
	3	4	1
	2	6	1
WAGE	2	3	4
	ADMIN	WORK	SICK
	1	3	4
	2	6	6
WAGE	9	3	4

[tim201110]

=sum(iferror((a4:a14=a4)*(b1:d11=b1)*b4:d14,)) CSE

[Thedude1234]

Oh wow, that worked like a charm! Thank you very much! Is there any way you could explain how this works? I would love to understand the inner workings of this function.