0

Word logo

If you need to total values in a Word table, you can do so without breaking out the calculator or entering the data into Excel and then copying it back. Word can do simple calculations such as summing, multiplying, and averaging.

Let’s say you have a table something like the following. You have the units sold and the per unit cost, and you want to multiply those to get a total.

table of sales figures in word

Start by placing your insertion point into the blank top cell in the “Total” column.

Next, switch to the new “Layout” tab that appears toward the right end of the Ribbon (there’s a separate Layout tab just for tables) and then click the “Formula” button.

click the formula button on the layout tab

 

In this example, we are going to multiply the value in the “Units” column by the value in the “Unit Cost” column. To do this, type the following into the “Formula” field to multiply the values in the two cells to the left of the current cell:

=PRODUCT(LEFT)

Read the remaining 23 paragraphs


Post a Comment Blogger

We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.

 
Top