Sumifs With Index/Match Column

Hi,

I have used this technique before with a sumif formula, to use the column that matches a reference cell but I cannot get this to work on a sumifs formula. What I have used previously in a sumif formula (only 1 criteria) is below.

=SUMIF(INDEX(INDIRECT("'Sales Q "&$H15&"'!$A:$AP"),0,MATCH(K$1,INDIRECT("'Sales Q "&$H15&"'!$1:$1"),0)-1),$A15,INDEX(INDIRECT("'Sales Q "&$H15&"'!$A:$AP"),0,MATCH(K$1,INDIRECT("'Sales Q "&$H15&"'!$1:$1"),0))

And this is the formula I currently have for my sumifs formula (multiple criteria).

=SUMIFS(INDEX('ACTUAL SALES'!$K:$AN,0,MATCH(B$20,'ACTUAL SALES'!$1:$1,0)),'ACTUAL SALES'!$C:$C,$B$7,'ACTUAL SALES'!$H:$H,$B$6)

I am using the match function to match up dates - if that gives you some sort of assistance in this.

Any help is greatly appreciated.

Cheers