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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum column of cells that already contain a formula
If the value appearing in cell G11 is zero, but the formula bar shows a
formula, then one of two problems is possible: 1. turn on automatic calculation: Tools Options Calculation Automatic 2. make sure the referenced cell have numbers rather than Text. -- Gary''s Student - gsnu200791 "engbe" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum column of cells that already contain a formula
Thanks for that...i had texts in some of the cells by mistake...I really
appreciate the help.Thank you once again! "Gary''s Student" wrote: If the value appearing in cell G11 is zero, but the formula bar shows a formula, then one of two problems is possible: 1. turn on automatic calculation: Tools Options Calculation Automatic 2. make sure the referenced cell have numbers rather than Text. -- Gary''s Student - gsnu200791 "engbe" wrote: 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! |
Reply |
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) |