Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formulae for adding a forward slash automatically into a cell | New Users to Excel | |||
Recalculation of formulae disabled | Excel Discussion (Misc queries) | |||
Displaying formulae changes formatting | Excel Worksheet Functions | |||
Change to formulae | Excel Worksheet Functions | |||
XL2002 Clipboard doesn't paste formulae | Excel Discussion (Misc queries) |