Adding formulae

[Guest]

Hi

I have downloaded a list and I have linked this to a summary, eg
B4=A1+A2+A3+A4, and B7 =A5+A6+A7+A35. Now I need a further level of summary
so that C7=A1+A2+A3+A4+A5+A6+A7+A35. However the formula in C7 has to show
the original cells in column A, i.e. "=A1+A2+A3+A4+A5+A6+A7+A35", it can't
just be =B4+B7. Can I somehow do this or do I have to manually type the
formula into C7?.

I'm using Excel XP.

Many thanks

VrB

 

[Guest]

Just type this in C7

=SUM(A1:A7)+A35

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks Clr, but I need to show the individual lines. This file will be used
by another program to form links from the original data, so I need to show
the formula as "=A1+A2+A3" etc.

 

[RagDyeR]

Will the formulas to be combined always have the identical relative location
to the cell containing this "double" formula?

i.e..
1 column left - 3 rows up
added to
1 column left