| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum column of cells that already contain a formula
Hi,
I want to add up all the values in a column. Each cell in that column already has a formula inside. For Example, Cell G4 has the formula: sum(A4:F4) Cell G5 has the formula: sum(A5:F5) Cell G6 has the formula: sum(A6:F6) ........ Cell G10 has the formula: sum(A10:F10) In cell G11 i want to sum up all the values of the previous G cells, when i put the formula: =Sum(G4:G10) into cell G11, I get a 0 value. I would really appreciate any help on this. I have been looking through past posts but have not been able to find an answer. Thank you in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't sort data when the key column cells contain formula | Excel Discussion (Misc queries) | |||
| How to apply a formula to all cells in a column | Excel Worksheet Functions | |||
| Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
| Formula to identify a keyword in all cells of a column | Excel Discussion (Misc queries) | |||
| Rounding formula won't copy to other cells in column - why? | Excel Discussion (Misc queries) | |||
Threaded Mode
