View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
BoniM BoniM is offline
external usenet poster
 
Posts: 97
Default Sum a column with spaces - how?

Even tho they don't show in Word, the columns and rows use the same naming
convention as Excel. So if, for example, your values are in the third column
and your total is in row 10, change the formula to read =SUM(C1:C9) and a
blank cell won't stop it.
Just in case you're not familiar with Excel at all... columns are lettered
left to right and rows numbered top to bottom. The location in the fifth
column and the seventh row would be E7.

"Martin ©¿©¬ @nohere.net" wrote:

Hi
I have a column of figures in UK pounds, with blank spaces in it
because there are headings in the column to the left
How do I add/sum/formula this column
Each time I try =SUM(ABOVE) the total is incorrect
Any help will be greatly appreciated
--
Martin
©¿©¬