'Google Sheet SUMIFS formula returning 0?

I have a SUMIFS formula in Google Sheets which is the following:

=SUMIFS('AWIN MASTER'!$AW:$AW,'AWIN MASTER'!$AT:$AT,">=" &A101,'AWIN MASTER'!$AT:$AT,"<" &A102)

This formula is the sum of a cost on another sheet, when the date is between two dates on the current sheet.

which is returning 0 when it shouldn't... it's working for my other formula but not mine... Could someone help please?

Solution 1:^[1]

try:

=SUM(IFERROR(FILTER('AWIN MASTER'!AW:AW; 
                    'AWIN MASTER'!AT:AT >= A101;
                    'AWIN MASTER'!AT:AT <  A102)))

or see if you got the right conditions:

=FILTER('AWIN MASTER'!AW:AW; 
        'AWIN MASTER'!AT:AT >= A101;
        'AWIN MASTER'!AT:AT <  A102)

I found that it was because of formatting through IMPORTRANGE

Thank you all for your help!

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	player0
Solution 2	Clo Blue