Can SUMIF show blank for 0 result?

Question

=SUMIF(Auto_Tracked!B1:B300,"rcumbaa",Auto_Tracked!D1:D300)

I would like it to show blank rather than 0 if possible

Answer 1

Simply place your formula in an IF statement to give you a blank cell if the result is 0.

Updated code:

=IF((SUMIF(Auto_Tracked!B1:B300, "rcumbaa",Auto_Tracked!D1:D300))=0,"",(SUMIF(Auto_Tracked!B1:B300, "rcumbaa",Auto_Tracked!D1:D300)))

This will check to see if the calculation results in a 0, and leave the cell blank if it is true. Otherwise, it will use the calculation results.

Answer 2

You could hide zeroes with a conditional format. Click Conditional Formatting > New Rule and select Format only cells that contain.... Make the rule Cell value is 0 and set the text color to the same value as the background color (usually white).

Answer 3

I would format the cells to not show a zero value. Right click on the cells that you want to hide the zero in and apply the formatting for the positive value followed by a ; negative values; zero values. In the example below, the positive values show the cell color, negative values are red and the zero values are blank.

Answer 4

This can be easily achieved by a simple formula:

=TEXT(SUMIF(Auto_Tracked!B1:B300,"rcumbaa",Auto_Tracked!D1:D300),"#")