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

Hi,
Beware of the way you write your numbers in the cells :
The "thousands" separator must be a non secable space (CTRL+SHIFT+SPACE) or
must not exist. That is for french version, I did not paractice with other
versions.
I you write in one cell : 1 200 , and in the other 2 300 (with ordinary
spaces) the SUM will be 503 because WORD "sees" 4 numbers. You can write the
units after the numbers, it does not matter.
--
bernard


"challa prabhu" wrote:

Hi,

If you use mathematical function, you have to view Word tables similar to
Microsoft Excel speadsheet.
For example, The column headings of Excel is A,B,C and so on, will have to
considered the simlar way when you work in Word Table. And the way you
refernce the cells in Excel will be the same in Word too.

Assuming that you have three columns, and you want the product of column 1
and two in column three. you will enter the fomula this way:

1. Place the insertion point in Column three.
2. Press Ctrl+9 to create the braces{}.
3. Enter the formula inside the brace by preceding with the symbol "="
The formula you enter should like this {=A1*B1}. You can brackets to specify
the order of caluclation.
4. Press F9 to recalculate the product details to display the current value.

Challa Prabhu


"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
©¿©¬