Adding formulae
 

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

Adding formulae
 

Just type this in C7

=SUM(A1:A7)+A35

Vaya con Dios,
Chuck, CABGx3

"violasrbest" wrote:

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

Adding formulae
 

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.

"CLR" wrote:

Just type this in C7

=SUM(A1:A7)+A35

Vaya con Dios,
Chuck, CABGx3

"violasrbest" wrote:

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

Adding formulae
 

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

--

Regards,

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

"violasrbest" wrote in message
...
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.

"CLR" wrote:

Just type this in C7

=SUM(A1:A7)+A35

Vaya con Dios,
Chuck, CABGx3

"violasrbest" wrote:

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