sum multiple columns based on 3 criteria

[rossi_69]

Good afternoon everyone, I would like some help with a formula which will sum all columns falling under the following criteria.
In the PI% tab Rows 1 to 5 are labelled Quarter, Month, Col, Week and WC.
In the Monthly Totals Tab I need to lookup the name in Column A then sum all entries in the rows headed with col 3 and month 2
As you can see I have the Month number and the Col number referenced in cells C2 and C3 in the Monthly Totals Tab.
I have managed to do the weekly Totals tab with an index match formula but this only finds the first instance of the criteria being met.

{=INDEX('PI%'!$Y$10:$AFX$73,MATCH($A10,'PI%'!$A$10:$A$73,0),MATCH($C$1&$C$2,'PI%'!$Y$2:$AFX$2&'PI%'!$Y$3:$AFX$3,0))}

Any help pointing me in the right direction with this problem would be greatly appreciated as I have been stuck now for a while.

[tim201110]

this?
=SUM(INDEX('PI%'!$Y$10:$AFX$73,MATCH($A10,'PI%'!$A$10:$A$73,),)*($C$1='PI%'!$Y$2:$AFX$2)*ISNUMBER(MATCH('PI%'!$Y$3:$AFX$3,$C$2:$G$2,)))

[rossi_69]

Thanks tim201110, this works great for me.