Leave cell blank where the sum is = to 0.

[pdeemartin58]

I want to sum the values for a range of cells but want the cell to remain blank if the formula returns a value of 0. I'm sure it's a simple formula but I've googled and read a lot of FAQs but haven't been able to get the correct formula for my needs.

Thank you in advance
Patrick

 

[6StringJazzer]

=LET(S,SUM(A1:B2),IF(S=0,"",S))

where A1:B2 is "a range of cells"

 

[pdeemartin58]

=LET(S,SUM(A1:B2),IF(S=0,"",S))

where A1:B2 is "a range of cells"

My range of cells is K19:M19. When I enter =LET(S,SUM(K19:M19),IF(S=0,"",S)) it returns #NAME? whether or not there are any values in that range.

 

[Joe4]

It sounds like you do not have the LET function. Are your really using Excel 365?

If not, this should work:

=IF(SUM(A1:B2)=0,"",SUM(A1:B2))

Note that you could also use Conditional Formatting or Custom Formatting to simply hide the zeroes.

 

[Scott Huish]

You could also just do:
=SUM(K19:M19)

and use a custom number format on this cell: General;-General;