Title: Tablepress Reference Value In Another Cell, Same Table
Last modified: November 28, 2019

---

# Tablepress Reference Value In Another Cell, Same Table

 *  Resolved [caljim](https://wordpress.org/support/users/caljim/)
 * (@caljim)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/tablepress-reference-value-in-another-cell-same-table/)
 * I have columns of numbers and I totaled them with =number_format(SUM(C2:C51)).
   The works. However, I need to show thousands separators in most numbers. If I
   use something like this in the cell it works: =number_format(577737).
 * Now the problem. If I put =number_format(577737) in a cell that is summed as 
   above then it crashes =number_format(SUM(C2:C51)). So I’m trying a hidden cell
   for the formula and I want to put the value from =number_format(577737) in a 
   cell that is summed, hoping to not crash the sum formula.
 * I tried using =D51 but that gives an error in both the summed cell and the sum
   formula cell: !ERROR! D51 does not contain a number or expression.
 * Now what?
 * It would be wonderful if we could format the whole columns with the thousands
   separator instead of hacking each cell!
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Ftablepress-reference-value-in-another-cell-same-table%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/tablepress-reference-value-in-another-cell-same-table/#post-12185208)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * The best chance for working with formatted data is to first create the complete
   table without any `NUMBER_FORMAT` calls. After that, insert new columns in the
   table, e.g. a new column `E`, in which you then only add
 *     ```
       =NUMBER_FORMAT(D5)
       ```
   
 * (for each row with the correct number).
 * Regards,
    Tobias
 *  Thread Starter [caljim](https://wordpress.org/support/users/caljim/)
 * (@caljim)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/tablepress-reference-value-in-another-cell-same-table/#post-12185923)
 * Thank you. That does work for numbers in the display column with the NUMBER_FORMAT’s
   in each cell but I can’t make anything work for the totals at the bottom. I could
   hide the input column with the NUMBER_FORMAT for the totals mirrored in the display
   column if there was some way to show the value from SUM in the display column/
   mirror only the value.
 * When I try this with a simple =C52 in the display column it doesn’t mirror the
   value and I have this message:
 * !ERROR! C52 does not contain a number or expression
 * I would love to let users make some changes in the columns for their analysis
   but not have that change in the db. I’m sure that is asking too much of any WP
   data table though.
 * Great support for an O/S project!!!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/tablepress-reference-value-in-another-cell-same-table/#post-12186590)
 * Hi,
 * what does cell C52 contain? A `NUMBER_FORMAT` formula? If so, you’d need to move
   that to the target cell as well. Basically, the approach would need to be duplicated
   for the `SUM` row, just with an extra row.
 * Unfortunately, TablePress does not contain a possibility to allow users to change
   the values, sorry.
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Tablepress Reference Value In Another Cell, Same Table’ 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/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [6 years, 6 months ago](https://wordpress.org/support/topic/tablepress-reference-value-in-another-cell-same-table/#post-12186590)
 * Status: resolved