Currently Being ModeratedNov 6, 2012 2:22 AM (in response to Simon De Trey -White)
From your description of the problem, it appears your SUM does not cover the entire range of cells you want summed.
Click on the cell with the SUM formula. Click on the range in that formula. The blue highlighted box should now have a little circle in the lower right. Drag down on it to expand the box to cover the other cells you want summed.
Currently Being ModeratedNov 6, 2012 5:49 AM (in response to Simon De Trey -White)
Numbers has a shortcut notation for cell ranges. You may be able to use the shortcut to advantage here. If you want to Sum all the figures in a particular column, don't name the rows explicitly, just use the column ID. For instance, to sum all the figures in column C, write: =SUM(C). If you want the expression to reside in column C along with the data, create a Footer Row for the Expression and that way it won't force an error message because of being included in the range. Expressions like SUM(C) only work on the Body rows, not Header and Footer rows.
Currently Being ModeratedNov 6, 2012 6:28 AM (in response to Jerrold Green1)
Great, thanks guys, so simple when you know how!