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!

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!

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!