CODEWITHSUNDEEP
google-sheetssumifs
Clo Blue
Clo Blue

Reputation: 21

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?

Upvotes: 1

Views: 1071

Answers (2)

Clo Blue
Clo Blue

Reputation: 21

I found that it was because of formatting through IMPORTRANGE

Thank you all for your help!

Upvotes: 0

player0
player0

Reputation: 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)

Upvotes: 0

Related Questions