SumIF Function.

[Sigh]

I would like to Sum the Values in Cell A1:A2. It depend
on the critial. If either Cell A1 or A2 is empty then the
Cell A3 will be equal to empty. If either Cell A1 or A2
contain the number then Cell A3 should sum up the value on
A1:A2.

Any help would be very appreciated.

 

[Dan E]

Not completely sure if you want a value when A1 AND A2 have values or if A1
OR A2 have values so . . .

If either Cell A1 or A2
contain the number then Cell A3 should sum up the value on
A1:A2.

=IF(AND(ISBLANK(A1),ISBLANK(A2)),"",SUM(A1:A2))
returns a value if A1 OR A2 contains a value

on the critial. If either Cell A1 or A2 is empty then the
Cell A3 will be equal to empty.

=IF(OR(ISBLANK(A1),ISBLANK(A2)),"",SUM(A1:A2))
returns a value if A1 AND A2 contain values

Dan E