PDA

View Full Version : sums in word tables



specops
05-11-2010, 11:16 AM
Is it possible to get a sum formular to work in word 2007 to multiply column 3 row 2 cells by column 4 row 2 and put the result in column 5 row 2

fumei
05-11-2010, 12:04 PM
Yes, but it must be manually updated. So if anything changes you have to update it yourself.

Put

{ = PRODUCT (c2,d2) }

in the cell in which you want the result.

If you are going to manually insert the field, you MUST use Ctrl-F9 to insert the curly brackets. It will not work if you just type them.

or use Tables > Formula and change the default =SUM.

BTW: using Word for mathematical operations in a table is, generally, not a good use of Word.

specops
05-11-2010, 01:29 PM
Thanks

I can get the sum to add the two columns together but i need to multple one figure by the other and the result in the final column.

I am using the formula tab to enter the code.

fumei
05-12-2010, 09:01 AM
"I can get the sum to add the two columns together but i need to multple one figure by the other and the result in the final column."

Ummm. Please read my post. That is exactly what it does.

"column 3 row 2 cells by column 4 row 2 and put the result in column 5 row 2"

column 3 row 2 = c2
column 4 row 2 = d2

PRODUCT is when you multiply...so....

In "the cell in which you want the result"

{ = PRODUCT (c2,d2) }