Sum a column with spaces - how?

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

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

On Mon, 19 Mar 2007 13:59:05 -0700, BoniM
wrote:

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.

Hi BoniM, that was great
Easy when one knows how
That's something else I've learned today
Thank You
--
Regards
Martin
©¿©¬

If your lover is overwieght then get them to walk 3 miles in the
morning and 3 miles in the evening and by the end of the week the fat
so and so should be 42 miles away

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

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