Sumifs formula isn't working correctly

**gjergji** · 09-20-2012, 04:13 PM

Please fix the SUMIFS formula in sheet5WORK2.zip

**NBVC** · 09-20-2012, 04:29 PM

What do you mean by fix?

I see results in some cells.. the 0's mean that you don't have matches to all criteria.... I think the Product Code is the most likely candidate...

Here is the formula without the external references...

=SUMIFS('Material Consumption'!$U$2:$U$32521,'Material Consumption'!$X$2:$X$32521,Sheet5!D2,'Material Consumption'!$Y$2:$Y$32521,Sheet5!A2,'Material Consumption'!$V$2:$V$32521,Sheet5!B2)

**gjergji** · 09-20-2012, 04:38 PM

there should be a lot more results

**NBVC** · 09-20-2012, 04:44 PM

Can you prove it with a sample or two?

**gjergji** · 09-20-2012, 04:53 PM

Sure product code 1000 should equal 20,964.00
but i see some thing wrong with the data but ill get back to you later if it doesn't get fixed thank you

**NBVC** · 09-20-2012, 05:15 PM

Maybe that last criteria range should be W instead of V?

=SUMIFS('Material Consumption'!$U$2:$U$32521,'Material Consumption'!$X$2:$X$32521,Sheet5!D2&"",'Material Consumption'!$Y$2:$Y$32521,Sheet5!A2,'Material Consumption'!$W$2:$W$32521,Sheet5!B2)