Maybe I'm missing something here, but what reason do you have for not simply
entering:

=A1+B1

Into C1, and then drag down (using the fill handle) to copy to C5?

OR, as an alternative,
Select C1 to C5, with the focus in C1 (colored white),
And enter

=A1+B1

And then hold <Ctrl, and hit <Enter,
Which will give you the exact same results (5 individual formulas) as the
"drag to copy" method.

Are you leaving something out of your explanation?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------




"BorisS" wrote in message
...
Peo, thanks for the assistance. I am a little confused on your example,
so
let me restate mine. If you can tell me directly what I should do, it
would
be great:

A1:A5
1 2 3 4 5
B1:B5
6 7 8 9 10

I need for C1:C5 to add each of A1+B1, A2+B2, etc., so that C1:C5 look
like
7 9 11 13 15

Thanks for any further assistance.
--
Boris


"Peo Sjoblom" wrote:

That is not an array formula, the result is correct, you are asking the
formula to sum all ranges. For instance if you have
1
2
3
4
5
6
7
8

in A1:A8 and you select B1:B2 and want the sum of A1:A4 in B1 and A5:A8
in
B2 you can use

=SUM(OFFSET($A$1,{0;4},,4,))

entered with ctrl + shift & enter


--

Regards,

Peo Sjoblom

"BorisS" wrote in message
...
I am having trouble with an array. I have a summary set of cells and
four
identical sets that need to sum into it (to be clear, I need each of
the
summary array cells to sum their respective cells from the four
identical
areas).

I am selecting the sum cell group, entering 'Sum(first range, second
range,
third range, fourth range)' (with none of those being named
ranges...just
starting cell to ending cell), and then doing ctrl-shift-enter. The
result I
am getting is the same in each of the sum cells, even though the input
cells
are clearly all different. What am I doing wrong?
--
Boris