SUMIFS Using ranges in the criterion

[bTrain]

Hi I am trying to create a SUMIFS formula that will SUM across a range On sheet Bank if their Description Equals the same as the Description Sheet 1 page, And the date on Bank Page falls between two ranges on Sheet 1.
I came up with this but it just equals 0

=SUMIFS(Bank!D2:D200,A2:A200,Bank!A2:A200,Bank!B2:B200,">=C2:C200",Bank!A2:A200,"<=D2:D200")

I think my problem lies here ">=C2:C200" and here "<=D2:D200".

Normally its ">=12/12/17", But i need it to match a range.

Any help is appreciated.

 

[FDibbins]

Re: SUMIFS Unsing ranges in the critirion

You are correct, that is indeed where the problem is. SUMIFS expects a single reference in it's criteria. If those ranges contain values, then maybe just add more criteria sets?
This part (Bolded) looks wrong too?
=SUMIFS(Bank!D2:D200,A2:A200,Bank!A2:A200,Bank!B2:B200,">=C2:C200",Bank!A2:A200,"<=D2:D200")

=SUMIFS(Bank!D2:D200,A2:A200,Bank!A2:A200,Bank!B2:B200,">="&C2,Bank!B2:B200,"<="&C200,Bank!A2:A200,"<="&D2,Bank!A2:A200,"<="&D200)