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) }
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.