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