CODEWITHSUNDEEP
excelsumsumifs
Kelley Hamrick
Kelley Hamrick

Reputation: 197

Sum multiple SUMIFS in Excel?

I'm trying to sum multiple SUMIFS formulas but it's not working.

When I use the following SUMIF, the answer is 8:

=SUMIFS('IN BETWEEN - ORG BASIS'!$AB$2:$AB$501,'IN BETWEEN - ORG BASIS'!$P$2:$P$501,'ORIGINS OF COOKSTOVES'!$A92,'IN BETWEEN - ORG BASIS'!$Z$2:$Z$501,'ORIGINS OF COOKSTOVES'!CN$1)

However, when I try to add another SUMIFS (which works by itself and equals 0), and sum those two, the answer changes to 0!

=SUM(AND(SUMIFS('IN BETWEEN - ORG BASIS'!$AB$2:$AB$501,'IN BETWEEN - ORG BASIS'!$P$2:$P$501,'ORIGINS OF COOKSTOVES'!$A92,'IN BETWEEN - ORG BASIS'!$Z$2:$Z$501,'ORIGINS OF COOKSTOVES'!CN$1),SUMIFS('IN BETWEEN - ORG BASIS'!$AH$2:$AH$501,'IN BETWEEN - ORG BASIS'!$AD$2:$AD$501,'ORIGINS OF COOKSTOVES'!$A92,'IN BETWEEN - ORG BASIS'!$AF$2:$AF$501,'ORIGINS OF COOKSTOVES'!CN$1)))

Does anyone know why this doesn't work?

Thanks in advance!

Upvotes: 0

Views: 273

Answers (1)

Kelley Hamrick
Kelley Hamrick

Reputation: 197

I don't know why it wasn't working with AND... but when I removed the AND( ), it worked perfectly.

Upvotes: 1

Related Questions