Hello,

I am trying to do the following:

1 - In Cell A4 display the SUM of A1 + A2 + A3 if at least one of these cells is not empty.

2 - In Cell A6 display A5-A4 if both cells are not empty.

How can I do this?

Thank You,
Miguel

= Sum(A1:A3)
...and...
=IF(AND(LEN(A5),LEN(A4)),A5-A4,"")

--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)




"Shapper" <(E-Mail Removed)>
wrote in message
news:25110584.2678.1325119728434.JavaMail.geo-discussion-forums@yqnd19...
> Hello,
>
> I am trying to do the following:
>
> 1 - In Cell A4 display the SUM of A1 + A2 + A3 if at least one of these cells is not empty.
>
> 2 - In Cell A6 display A5-A4 if both cells are not empty.
>
> How can I do this?
>
> Thank You,
> Miguel

On Dec 28, 7:48*pm, Shapper <mdmo...@gmail.com> wrote:
> Hello,
>
> I am trying to do the following:
>
> 1 - In Cell A4 display the SUM of A1 + A2 + A3 if at least one of these cells is not empty.
>
> 2 - In Cell A6 display A5-A4 if both cells are not empty.
>
> How can I do this?
>
> Thank You,
> Miguel

Hi Miguel,

Probably a couple of ways those formulas could be written, but here is
how I would approach them:

Cell A4 =IF(OR(A1<>"",A2<>"",A3<>""),SUM(A1:A3),"")
Cell A6 =IF(AND(A4<>"",A5<>""),SUM(A4:A5),"")

Hopefully that helps.
Charles

"Shapper" <(E-Mail Removed)> wrote:
> I am trying to do the following:
> 1 - In Cell A4 display the SUM of A1 + A2 + A3 if at
> least one of these cells is not empty.

=IF(COUNT(A1:A3)>0,SUM(A1:A3),"")

> 2 - In Cell A6 display A5-A4 if both cells are not empty.

=IF(COUNT(A4:A5)=2,A5-A4,"")