Getting rid of "zero" value while using SUMIF formula

[masud8956]

Hi,

I am using "SUMIF($H$777:$H$806,$G810,I$777:I$806)" formula in my worksheet. For blank cells in the input array the function returns "0". I prefer to have the output cells blank instead of "0" values.

What modification can I make in my formula?

I do not prefer to use VBA.

Thanks in advance!

 

[wideboydixon]

Easiest way is this:

=IF(SUMIF($H$777:$H$806,$G810,I$777:I$806)=0,"",SUMIF($H$777:$H$806,$G810,I$777:I$806))

WBD

 

[masud8956]

Worked perfectly! Thank you very much!!

 

[Joe4]

Or, rather than having to perform the function twice, you could simply hide the zero values.
There are three different ways to do that.
See: https://www.techrepublic.com/blog/microsoft-office/three-ways-to-hide-zero-values-in-an-excel-sheet/