Return Blank Cell if SUM of Two Columns is Blank

Question

I'm trying to copy a formula down a column. The formula is a sum of F2:G2, but in column H I wanted it not to show the zeros. How do I do that?

I've used the "IFERROR" for summation down a single column, as you can see with F & G, but I can't figure out how to return blank cells for sums in H.

Answer 1

Try the following.

=IF(SUM(F2:G2)=0,"",SUM(F2:G2))

Answer 2

Hi OutlookUser3656,

Good day! Thank you for posting to Microsoft Community. I am happy to help you.

You can use the formula below to check if both F and G cells are blank before calculating SUM value.

=IF(AND(ISBLANK(F2),ISBLANK(G2)),"",SUM(F2:G2))

If you would like to change the criteria to any of F and G cells showing blank, simply replace OR with AND in the formula can do the work.

Sincerely,

Ryan | Microsoft Community Moderator

***Note: In the event that you're unable to reply to this thread, please ensure that your Email address is verified in the Community Website by clicking on Your Account Name > "My Profile" > "Edit Profile" > Add your Email Address > tick "Receive email notifications" checkbox > click on "Save".***