Sum column of cells that already contain a formula

  • Thread starter Thread starter engbe
  • Start date Start date
E

engbe

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!
 
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.
 
Thanks for that...i had texts in some of the cells by mistake...I really
appreciate the help.Thank you once again!
 
Back
Top