Google Sheet SUMIFS formula returning 0?-CodePudding

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?

CodePudding user response：

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)

CodePudding user response：

I found that it was because of formatting through IMPORTRANGE

Thank you all for your help!