Title: Calculated Table Fields/Cells?
Last modified: August 21, 2016

---

# Calculated Table Fields/Cells?

 *  Resolved [spicer23](https://wordpress.org/support/users/spicer23/)
 * (@spicer23)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/calculated-table-fieldscells/)
 * Hello Tobias,
 * I’ve looked over your FAQ and Docs.
    Unless I missed it, is there a way to do
   calculation on a column or row like a simple **Total** to start with?
 * Please let me know how. Or, how I can donate to make
    this feature happen.
 * Thanks in advance for your response.
 * Best,
 * Emer
 * [http://wordpress.org/plugins/tablepress/](http://wordpress.org/plugins/tablepress/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/calculated-table-fieldscells/#post-3966963)
 * Hi,
 * thanks for your question.
 * Yes, the documentation on the math/formula functionality is pretty sparse at 
   the moment, but I’ll be working to improve that in the future.
 * But it’s not really difficult, and it works very similar to Excel:
    A formula
   starts with an = and then contains a mathematical expression, in which you can
   also reference values from other cells, by using their cell name. Here are two
   basic examples:
 *     ```
       =A1+B3
       ```
   
 * will sum the cells A1 and B3.
 *     ```
       =AVERAGE(C3:C10)
       ```
   
 * will calculate the average value of the cells from C3 through C10.
 * Other math functions that can be used are
 * >  sin, sinh, arcsin, asin, arcsinh, asinh, cos, cosh, arccos, acos, arccosh,
   > acosh, tan, tanh, arctan, atan, arctanh, atanh, sqrt, abs, ln, log, exp, floor,
   > ceil, average, max, min, mod, pi, power, round, sum, rand_int, rand_float
 * So, for the total sum of a column, you would use something like
 *     ```
       =SUM(B2:B15)
       ```
   
 * in the cell B16 for example.
    Does that help?
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

The topic ‘Calculated Table Fields/Cells?’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

## Tags

 * [calculation](https://wordpress.org/support/topic-tag/calculation/)

 * 1 reply
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [12 years, 10 months ago](https://wordpress.org/support/topic/calculated-table-fieldscells/#post-3966963)
 * Status: resolved