How to add Word table formulas SUM, PRODUCT, AVERAGE, IF and AND, with calculating specified cells
Chapters:
0:00 How to add sum formula in Word?
0:26 How to sum a specified number of cells in a column in Word?
0:58 How to calculate the product in Word?
1:57 How to use average formula in Word?
2:29 Multiple formulas are applied in combination, such as =IF() and =AND()
Our website: http://www.liangshunet.com/pub/items....
Description:
Note: In the formula, change cc to greater than sign.
How to add Word table formulas (SUM, PRODUCT, AVERAGE, IF and AND), with calculating a specified number of cells
One. How to add formulas in Word (insert formula in Word)
(1) How to add sum formula in Word?
1. If we want to sum the sales of "women's Clothes". Position the cursor to the last cell of the column "Sales (Pieces)", select the "Layout" tab, click "Formula" in the upper right corner to open the "Formula" window, and automatically fill in the input box under "Formula"=SUM(ABOVE).
2. Sum is the summation function, and ABOVE means to sum from top to bottom, that is, to sum a column. click "OK", the sum result is automatically filled in to the last cell of the column "Sales (pieces)".
3. If we sum from left to right (that is, sum a row), the formula should be written as =SUM(LEFT).
(2) How to sum a specified number of cells in a column in Word?
1. If we want to sum the first, third, fifth and sixth cells of the column "Sales (pieces)". Position the cursor to the last cell of the column to open the Formula window.
2. Still automatically fill in the formula for summing the whole column, change it to the formula of "summing the first, three, five, and six cells", that is, =SUM(E1,E3,E5,E6), click "OK" to sum the result of the specified four cells, see video.
Note: E in formula =SUM(E1,E3,E5,E6) represents the fifth column, and the number represents the row, for example, E1 represents the first row of the fifth column, because it is text, it does not participate in the operation.
Two. How to calculate the product in Word?
1. If we want to calculate the Total amount. Position the cursor to the last cell of the first row, open the "Formula" window, and automatically enter the summation formula, click the "Paste function" drop-down list box, select PRODUCT, PRODUCT() is added to the formula input box..
2. Delete the summation formula, then enter LEFT in PRODUCT() brackets, click "OK" to get the calculation result.
3. Select the calculation result, press Ctrl + C to copy, click the first cell under the calculation result, hold down Shift, and then click the penultimate cell of the column to select the remaining cells to calculate. Press Ctrl + V to paste and F9 to update.
Note:
A. After modifying the data, Word will not update automatically, we need to select the table and press F9 to update.
B. If the table has three columns of data, only two of them are calculated, and the formula =D2* E2 or =Product(D2, E2) is required. And each row needs to be calculated once.
Three. How to use average formula in Word?
Suppose we ask for an average price for the column "Price ($)". Position the cursor to the last cell of the column "Price ($)", open the "Formula" window, click the "Paste function" drop-down list box, select AVERAGE, delete the summing formula, enter ABOVE in parentheses of AVERAGE(), click "OK", see video.
Note: Averageis the same as Sum and Product, and we can also average the rows, the formula is =AVERAGE(LEFT); we can also specify cells.
Four. Multiple formulas are applied in combination, such as =IF() and =AND()
1. If we want to compare the sales of "White cotton t-shirt" in the second row with "Pink shirt" in the fifth row, and "White long sleeve shirt" in the fourth row and "White t-shirt" in the sixth row. Position the cursor to the last cell of the column "Sales (Pieces)", open the "Formula" window, enter the formula =IF(AND(E2ccE5,E4ccE6),1,0), click "OK", and the result is 0.
2. IF() returns 1 only if the expression is true, and the return result is 0, indicating that the expression is false, that is, the return value of AND(E2ccE5,E4ccE6) is false; E2 is greater than E5, but E4 is not greater than E6, so AND(E2ccE5,E4ccE6) returns false; The formula AND() returns true only if both expressions are true.
3. Although the size of the two pairs of values compared by the formula is very obvious, we can know at a glance, but if the table spreads pages, when we want to compare the sales distributed on different pages, it is effective to use such a formula.
Watch video How to add Word table formulas SUM, PRODUCT, AVERAGE, IF and AND, with calculating specified cells online without registration, duration hours minute second in high quality. This video was added by user Loinsure 21 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,464 once and liked it 21 people.