Combining 2 cells numbers unless one doesn't exist

[desk.doc]

I have worked with this solution for almost 2 days now. Can anyone help? I have 2 cells that combine into a 3rd cell; adding the first 2 cells together. What I'm looking to do: say A1 has a number and A2 does or doesn't have a value. I'm looking to return the value of the number in A2 only if there's a number. I looked at ISTEXT, COUNTIF, or possibly using an if statement. I'm not sure which way to go.

Thanks in advance!
D~

[Big Chris]

I could have misunderstood your query, but if A2 holds text and you try to add it to A1 it will show an error.....and that could be the trigger for reverting to an alternative sum?

i.e. =IF(ISERROR(A1+A2)=TRUE,A2,A1+A2)

Hope this helps?

Chris.

[jasoncw]

You could try something like this:

=A1+IF(ISNUMBER(A2),A2)

HTH

Jason

[desk.doc]

Thank you both for the reply. Jason hit it on the head with what I had added to the end of A2. Thank you.
D~

[Teethless mama]

I have worked with this solution for almost 2 days now. Can anyone help? I have 2 cells that combine into a 3rd cell; adding the first 2 cells together. What I'm looking to do: say A1 has a number and A2 does or doesn't have a value. I'm looking to return the value of the number in A2 only if there's a number. I looked at ISTEXT, COUNTIF, or possibly using an if statement. I'm not sure which way to go.

Thanks in advance!
D~

=SUM(A1:A2)

SUM function ignore text