Using SUMIFS with a date range

I am trying to Sum Total(Column D), if the Date(Column A) is between Date 1(I7) and Date 2(J7) and it is in a given Area(Column J). Various Sheets are involved.

My latest attempt is shown below(but gave me an error):

=SUMIFS('Historical Data'!$D:$D, 'Historical Data'!$J:$J, AUS!A3, "<='Historical Data'$A:$A",AUS!I7, ">="Historical Data'$A:$A,AUS!J7)

I would appreciate any help

Do you mean this:

=SUMIFS('Historical Data'!$D:$D, 'Historical Data'!$A:$A, ">="&AUS!I7, 'Historical Data'!$A:$A, "<="&AUS!J7)

Yep, exactly. Thanks so much.

Hi,

Try this.

=SUMIFS('Historical Data'!$D:$D,'Historical Data'!$J:$J,AUS!A3,'Historical Data'!$A:$A,">="&AUS!I7,'Historical Data'!$A:$A,"<="&AUS!J7)

HTH
Steve