Sumifs returning 0 instead of Blank,

[HdCpr]

Hi

hopefully anyone can help me
please see below formula
I am trying to return blanks in an order template I am trying to see if there is no forecast, but instead of n/a or blank sumifs comes with 0
actually some lines has very low volume so I want to see zeros as well
Can you help

=IF(SUMIFS(RAW!$M$2:$M$301,RAW!$E$2:$E$301,ORDER!N$3,RAW!$A$2:$A$301,ORDER!$B4)/16="","",SUMIFS(RAW!$M$2:$M$301,RAW!$E$2:$E$301,ORDER!N$3,RAW!$A$2:$A$301,ORDER!$B4))

 

[Peter_SSs]

SUMIFS returns the sum of cells that meet the given criteria. If no cells meet the criteria then the sum will be zero. Since SUMIFS returns a sum (number), it cannot return "" because that is a text value.

Perhaps you want this?
=IF(SUMIFS(RAW!$M$2:$M$301,RAW!$E$2:$E$301,ORDER!N$3,RAW!$A$2:$A$301,ORDER!$B4)=0,"",SUMIFS(RAW!$M$2:$M$301,RAW!$E$2:$E$301,ORDER!N$3,RAW!$A$2:$A$301,ORDER!$B4))

 

[HdCpr]

SUMIFS returns the sum of cells that meet the given criteria. If no cells meet the criteria then the sum will be zero. Since SUMIFS returns a sum (number), it cannot return "" because that is a text value.

Perhaps you want this?
=IF(SUMIFS(RAW!$M$2:$M$301,RAW!$E$2:$E$301,ORDER!N$3,RAW!$A$2:$A$301,ORDER!$B4)=0,"",SUMIFS(RAW!$M$2:$M$301,RAW!$E$2:$E$301,ORDER!N$3,RAW!$A$2:$A$301,ORDER!$B4))

Thank you for your response
Life is much better when the one has know the knowledge ?
Yes it is what I want . And much appreciated your time

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

 

[squido96]

You're welcome. Thanks for the follow-up.

Hey! I know this was a really long time ago, but could you break down exactly what this if + sumif combo is doing using a casual sentence?

I know you're nesting the SUMIF within the IF statement, so I assume it's something like: "if this conditional sum function finds a 0 in a cell, return a blank" but i feel like there's more to it...right? let me know! (and thank you in advance!)