- Go to Editor of Data Table.
- Select a cell and start typing. In a cell, type an equal sign “=” to start the formula.
Check the list of formulas which supported by Data Tables on this page.
- Fill in the rest of the formula.
- Choose one of the available functions, then inside the parentheses “()” type the cells you need – inserting an operator between them. It will look like this
=SUM(B2;C2;D2)
- Type a combination of numbers and operators; for example,
=3+7
. - Type a name of cells (inserting an operator between them). For example, type B1 and then type a plus sign (+), type C1 and type +, and then type D1.
=B1+C1+D1
- Save the changes of table.
- Check the result of formula in the table on your site.
Do one of the following:
The result of the formula in the table you can’t see in the editor of table in WordPress admin area, only in the table on your site.
2013 | 2014 | 2015 | Total | |
winter | 215 | 198 | 852 | 1265 |
spring | 300 | 354 | 324 | 978 |
summer | 115 | 246 | 147 | 508 |
autumn | 97 | 222 | 752 | 1071 |
Total | Total | 3822 |