Simple One

W

Wanna Learn

Hello I want to add column A and column B, but if the total is zero I do
not want the zero to show, I tried =if(a2+a3=0), " ",)a2+a2) .. but it is
obviously wrong thanks
 
B

Bob I

contents of C2 will be the following, and display the sum of the
adjacent cells in column A with column B.

=if(A2*B2, A2+B2,"")

Not sure what you were doing adding up rows. A2 + A3 is row addition.
 
D

David Biddulph

The OP asked for the zero not to show if the TOTAL is zero, not if the
PRODUCT is zero, so you could change that to
=if(A2+B2, A2+B2,"")
 
Top