formula help needed

[pylotttt]

I have cells A1, B1 and C1 with a default of no value and A4 with a positive number.

What I need to do is subtract the values from cells A1-C1 from A4 but only display a number in the formula cell E1 if there are numbers entered in A1, B1, or C1.
If there are no numbers entered into cells C1-C3 I want to return a blank in the formula cell E1.


=IF(A1-B1-C1="","",A4-A1-B1-C1) Doesn't work but that is basically what I want.

 

[shg]

Try =if(count(a1:c1), a4-sum(a1:c1), "")

 

[pylotttt]

Excellent. It works fine.
Thanks