Title: Calculations
Last modified: December 1, 2017

---

# Calculations

 *  Resolved [docrocks](https://wordpress.org/support/users/docrocks/)
 * (@docrocks)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/calculations-8/)
 * I love using TablePress for static tables but I want to create a dynamic table(
   [see the webpage example](http://www.haverhilldems.org/test-tablepress/))to keep
   track of who commits to the Action in Column A. The user clicks on **Done ** 
   which causes the number displayed in column C is increment by one.
 * TablePress 1.8.1 descriptions say math formula calculations in a cell are possible.
   I have tried the usual spreadsheet formula (=b3+1) and it gives the error !ERROR!
   undefined variable ‘b3’ as you see on the example web page. Note that when this
   table goes live I will hide Rows 3 and 5.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcalculations-8%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/calculations-8/#post-9742042)
 * Hi,
 * thanks for your question, and sorry for the trouble.
 * The reference to (for example) B2 is not working because that cell has text in
   it. You probably want B3 there.
    Also, please use the uppercase letters for the
   columns.
 * Regards,
    Tobias

Viewing 1 replies (of 1 total)

 The topic ‘Calculations’ 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/)

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