SUMIF values in date range not working

[DSGN1]

Hi there, I've gotten this to work before but it's not now.

I'm trying to total the commissions for any sales made within a date range. For some reason, though I've entered the formula exactly how I believe it's worked before, isn't working. 

For example in the last sheet in the attached file, M7 is supposed to sum all amounts from Column D for any sales made between dates H7 and I7 ($500 total). Instead it's coming back with a totally wrong number, and I have no idea where it's pulling that total from. 

Please help.

[#2 · Accepted solution]

@DSGN1 ,

=SUMIFS(D4:D60,B4:B60,">="&H7,D4:D60,"<="&I7)

it shall be B column for the second criteria

[#3]

Thanks!

[#4]

What would be the formula if I wanted it to sum that date range 3D, across all sheets in the workbook?

[#5]

@DSGN1 , there are two ways, both are explained here https://www.myonlinetraininghub.com/excel-3d-sumif-across-multiple-worksheets