View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
engbe engbe is offline
external usenet poster
 
Posts: 9
Default 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!