I'm looking for a way to make sum only if one of both cells are not blank otherwise leave the sum cell blank. I'm working w/ Google Sheets. Here is my formula for the moment: =SUM(L6; K7;-J7) the same formula will be on 90 cells on the same column. If anyone could help! Sincerely!

CodePudding user response：

You can you use the combination of IF() and AND() methods in google sheet :

=if(and(ISBLANK(A2),ISBLANK(B2)),"",SUM(A2:C2))