Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.tables
|
|||
|
|||
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 ©¿©¬ |
#2
Posted to microsoft.public.word.tables
|
|||
|
|||
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 ©¿©¬ |
#3
Posted to microsoft.public.word.tables
|
|||
|
|||
Sum a column with spaces - how?
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 |
#4
Posted to microsoft.public.word.tables
|
|||
|
|||
Sum a column with spaces - how?
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 ©¿©¬ |
#5
Posted to microsoft.public.word.tables
|
|||
|
|||
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 ©¿©¬ |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Breaks for Illustrations in 2 Column Table | Tables | |||
How do I change a text column to a number column when merging? | Microsoft Word Help | |||
How to paste a column of text into a column in a Word Table | Page Layout | |||
How can I replace single spaces with double spaces in a docume | Microsoft Word Help | |||
I cannot type two sequential letters or spaces or back spaces? | Microsoft Word Help |