The sum of 2 cell if a cell is not blank

Copper Contributor

If a cell has content (not empty), I am trying have the the sum of 2 different cells only if a cell has content. If that cell is blank then the other cell is blank, not 0. It seems so simple, yet I have had nothing but errors. Help would be greatly appreciated.

 

clipboard_image_1.png

1 Reply

@JimJJ 

 

Try this one in N13

 

=IF(ISBLANK(B13),"",H13+L13)