Blank a cell if value is zero

Troy Bjelland

I apologize as I know this has been asked numerous time but i cannot get it to work for me. I have a IfSum formula that I would like to turn the cell blank if the value is zero.

=SUMIFS({Sheet - Order Report Range 2}, {Sheet - Order Report Range 1}, "Badges", {Sheet - Order Report Month}, "February")

Thanks in advance for all the help

Jeff Reisman

@Troy Bjelland

You just need to embed your SUMIFS inside an IF as a logical statement:

=IF(SUMIFS({Sheet - Order Report Range 2}, {Sheet - Order Report Range 1}, "Badges", {Sheet - Order Report Month}, "February") = 0, "", SUMIFS({Sheet - Order Report Range 2}, {Sheet - Order Report Range 1}, "Badges", {Sheet - Order Report Month}, "February"))

In English: If this formula equals zero, leave the cell blank (begin quotes and end quotes with nothing in between - "" ), otherwise, put the formula result in the cell.