how to apply sum formula in ms word 2010

how to apply sum formula in ms word 2010

Share this video:
youtu.be/svKIUj_1xoM

How To Remove Password In Windows 10 8 7 With PC Unlocker Urdu Hindi
youtu.be/De63X922Xmo

Aggregate a section or line of numbers in a table

Applies To: Word 2013

To include a section or line numbers in a table, utilize the Formula charge.

Tap the table cell where you need your outcome.

Tap the Table Tools Layout tab and snap Formula.

Recipe catch for table apparatuses

Check between the brackets to ensure Word incorporates the cells you need in the total.

Whole recipe in the equation box

=SUM(ABOVE) includes the numbers in the section over the cell you're in.

=SUM(LEFT) includes the numbers in the line to one side of the cell you're in.

=SUM(BELOW) includes the numbers in the section beneath the cell you're in.

=SUM(RIGHT) includes the numbers in the line to one side of the cell you're in.

In the event that you roll out improvements to the numbers you're including, select the entirety and press F9 to demonstrate the new outcomes.

You can likewise utilize more than one recipe in a table. For instance, you can include every line of numbers in the right-hand section, and afterward you can include those outcomes at the base of the segment.

Different equations for tables

Word incorporates different capacities for tables—for instance, AVERAGE and PRODUCT.

Tap the table cell where you need your outcome.

Tap the Table Tools Layout tab and snap Formula.

Equation catch for table apparatuses

In the Formula box, erase the SUM equation, yet keep the equivalent sign (=). At that point tap the Paste work box and tap the capacity you need.

Equation box with capacity menu

Between the enclosures, pick which table cells you need to incorporate into the equation:

Sort ABOVE to incorporate the numbers in the segment over the cell you're in and click OK.

Sort LEFT to incorporate the numbers in the column to one side of the cell you're in and click OK.

Sort BELOW to incorporate the numbers in the section beneath the cell you're in and click OK.

Sort RIGHT to incorporate the numbers in the line to one side of the cell you're in and click OK.

For instance, to normal numbers in the line to one side of the cell, click AVERAGE and sort LEFT:

=AVERAGE(LEFT)

To increase two numbers, click PRODUCT and sort the area of the table cells:

=PRODUCT(ABOVE)

TIP: To incorporate a more particular scope of cells in a recipe, you can allude to particular cells. Envision every section in your table has a letter and every line has a number, as in a Microsoft Excel spreadsheet. For instance, to duplicate the numbers from the second and third segments in the second line, sort =PRODUCT (B2:C2).



***Website: thesoftsense.com/

***Subscribe our YouTube Channel:
youtube.com/channel/UCsuI1AWKK31iXzhKtG-zTfg?su…

***Facebook:


***Google:
plus.google.com/u/0/111849326672730286270

***Twitter:
twitter.com/nouman86ryk1

***If you like this video so share it and subscribe our Channel now for more videos.

how to apply sum formula in ms word 2010