Home |
Search |
Today's Posts |
#1
|
|||
|
|||
total subtotal cells
i created manual subtotal cells in a column and now want to add them up but
not using auto subtotal feature. Does anyone know how to do this? Many moons ago I was able to do it in Lotus..... if that helps. -- MJ |
#2
|
|||
|
|||
maybe I've misunderstood your q but in the cell where you wish the total of
the sub totals to appear =sum(cell ref for sub total a + cell ref sub total b + etc etc) "Mary" wrote: i created manual subtotal cells in a column and now want to add them up but not using auto subtotal feature. Does anyone know how to do this? Many moons ago I was able to do it in Lotus..... if that helps. -- MJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have cells with diffent color fonts and need to total based on . | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
In SUM cells the # sign keeps showing instead of total | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |