Formula/Sum Question

[Jon the Contractor]

If i have a dollar value in cell a1 and no value in cell a2 and the sum
formula in cell a3, a3 returns the value of cell a1 since it is the only cell
with a value in it. Is there a formula that will sum a1 and a2 only when
they both have values in them?

 

[Fred Smith]

Try it this way:
=if(count(a1:a2)=2,a1+a2,"what you want when not filled in")

Regards,
Fred.

 

[T. Valko]

Another one:

=(COUNT(A1:A2)=2)*(A1+A2)