how to make formula not sum a cell if cell value are ""

[abrunstad]

Happy weekend everyone!

I am trying to make a formula that does this;

Sum up A1 and A2 AND A3
If: A1 OR A2 OR A3 is "", olny sum the ones that are a number value.


Anyone?

in formula; =If(a1 or a2 or a3="";ONLY SUM UP THE ONES THAT ARE NOT "".

[oldchippy]

=SUM(A1:A3) will sum the values in the cells if the cells are blank then zero

[abrunstad]

Yes, i know, but you see I have the A1, A2, A3 returning a value "" so that they are hidden and not showing the 0, but appear as blank.

[oldchippy]

What are the formula's in A1, A2, A3

[abrunstad]

Please see the cell B35 for an illustration of the problem.
this is in sheet "produksjonsplan".

Andreas.

[oldchippy]

Here's one way

=IF(B34="",B33,B33+B34)

[martindwilson]

=SUM(B33:B34) and =SUM(D33:D34) works just fine i cant see any problem!

[abrunstad]

I found out that the problem occur if I set the cell to =A1+A2+A3.
And then, it works fine when i set =Sum(A1:A3)