ranges in arrays, is this possible?

[HGood]

I'm new to arrays, but this is what I'm trying to do.

In Row 1 I insert "2" in cells A11.
In Row 2 I insert "4" in cells A22.
In Row 3 I insert "6" in cells A33.
In Row 4 I insert "8" in cells A44.

If I type the array {=(A1:A4)+(D14)} in cells E1:E4, I get the totals
4,8,12,16.

But is there a way, using an array, to include columns B and C in this
total?

I tried arrays such as:
{=sum(A1:A4)D14)} doesn't work
{=sum((A1:A4)D14))} doesn't work
{=(A1:A4)+(B1:B4)+(C1:C4)+(D14)} gives the 8,16,24,32 totals I want, but
if I want to include more columns I was hoping to do it without having to
list every column.

Is there a shorter way to come up with the same result?

Thanks

 

[Frank Kabel]

Hi
try
=SUM(A1:A4,D14)

 

[HGood]

I tried it but this just gives "40" in the four cells E1:E4. It should be
4,8,12,16.

Any other suggestions?

Harold

=============

 

[HGood]

OOPs, this is the correct response.

I tried it but this just gives "40" in the four cells E1:E4. It should be
8,16,24,32.

Any other suggestions?

Harold

=============

 

[Alan Beban]

I'm new to arrays, but this is what I'm trying to do.

In Row 1 I insert "2" in cells A11.
In Row 2 I insert "4" in cells A22.
In Row 3 I insert "6" in cells A33.
In Row 4 I insert "8" in cells A44.

If I type the array {=(A1:A4)+(D14)} in cells E1:E4, I get the totals
4,8,12,16.

But is there a way, using an array, to include columns B and C in this
total?

I tried arrays such as:
{=sum(A1:A4)D14)} doesn't work
{=sum((A1:A4)D14))} doesn't work
{=(A1:A4)+(B1:B4)+(C1:C4)+(D14)} gives the 8,16,24,32 totals I want, but
if I want to include more columns I was hoping to do it without having to
list every column.

Is there a shorter way to come up with the same result?

Thanks

=SUM(A11) and fill down.

Alan Beban