How to merge two different formulas

[hirenhkansara]

Hi..
My name is Hiren.

I am facing some problem for adding one cell formula to another cell formula. I use COPY >> PASTE SPECIAL >> ADD and all the time formula of second cell is added with result value of first cell.
EX:
[1]
Cell D3 contains A3+B3+C3
Cell D4 contains B4+C4
Cell D5 contains A5+C5
Cell D6 contains A6+B6+C6
.
.
.

[2]
Cell H3 contains F3+G3
cell H4 contains E4+F4+G4
Cell H5 contains G5
Cell H6 contains F6+G6
.
.
.

Now I want to merge two cells formula.
Finaly I need result in H column like below :

Cell H3 should contain : F3+G3+A3+B3+C3
Cell H4 should contain : E4+F4+G4+B4+C4
Cell H5 should contain : G5+A5+C5
Cell H6 should contain : F6+G6+A6+B6+C6

Can any one please share the solution for above.
Awaiting for positive reply.
Thanks.
Hiren

[Pete_UK]

This is a duplicate post of this one:

http://www.excelforum.com/excel-gene...-formulas.html

Do not multi-post (check out the Forum Rules)

Pete

[hirenhkansara]

Hi.. Pete.

Noted.
Can you suggest solution..!!

Rgds,
HIREN

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.