| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
SUM TOTAL
I need help with totaling a range of cells G12:G46. My problem is that not
all cells contain values for the formula in these cells so it is not allowing me to do so. This is on a quote sheet and I would like to subtotal as I go, can anyone help? -- Chris |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
SUM TOTAL
see your other post
-- Biff Microsoft Excel MVP "Chris" wrote in message ... I need help with totaling a range of cells G12:G46. My problem is that not all cells contain values for the formula in these cells so it is not allowing me to do so. This is on a quote sheet and I would like to subtotal as I go, can anyone help? -- Chris |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
SUM TOTAL
What sort of data do you have in the cells? You may be able to use the
subtotal function to add data in groups, by sorting first on the relevant columns and using data - subtotals in 2003 or the subtotals option on the ribbon in 2007. Can you give a bit more detail? "Chris" wrote: I need help with totaling a range of cells G12:G46. My problem is that not all cells contain values for the formula in these cells so it is not allowing me to do so. This is on a quote sheet and I would like to subtotal as I go, can anyone help? -- Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Linear Mode
