Title: SUM across multiple tables
Last modified: October 19, 2017

---

# SUM across multiple tables

 *  Resolved [Lukosius](https://wordpress.org/support/users/lukosius/)
 * (@lukosius)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/)
 * I need to add up (SUM) a bunch of cells from multiple tables, with the results
   going into a separate (summary) table. Is this possible?
 * e.g. Table1 (cell C3) + Table2 (cell D8) + Table3 (cell F5) = (the result goes
   into a cell in Table4).
 * A simple process really, and similar to having formulas span multiple worksheets
   in Excel.
 * Creating formulas within a table is easy, but I can’t find any documentation 
   relating to creating formulas across multiple tables.

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9602245)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * For this, you could use the TablePress Extension from [https://tablepress.org/extensions/table-cell-shortcode/](https://tablepress.org/extensions/table-cell-shortcode/),
   which allows to retrieve the value of a single cell from a table. (Note that 
   this will always retrieve the raw data, so that this can not be used to e.g. 
   retrieve the result of a formula in the table.)
 * You can then insert these Shortcodes into the cell of another table as well. 
   However, in order to use it in another formula in that table, you will also need
   the TablePress Extension that is explained at [https://wordpress.org/support/topic/referencing-data-from-another-tables-and-formulas/#post-7012433](https://wordpress.org/support/topic/referencing-data-from-another-tables-and-formulas/#post-7012433)
 * Regards,
    Tobias
 *  Thread Starter [Lukosius](https://wordpress.org/support/users/lukosius/)
 * (@lukosius)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9602255)
 * Thank you very much. I will give that a try.
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9602344)
 * Hi,
 * no problem! I hope that this helps!
 * Regards,
    Tobias
 *  Thread Starter [Lukosius](https://wordpress.org/support/users/lukosius/)
 * (@lukosius)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9602354)
 * That worked beautifully. Thank you so much.
 *  Thread Starter [Lukosius](https://wordpress.org/support/users/lukosius/)
 * (@lukosius)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9602420)
 * Could you also take a look at another problem we have in regards to viewing some
   tables on a mobile phone, specifically this page….
 * [http://www.goldfieldsgiants.com/statistics/stats-2017/](http://www.goldfieldsgiants.com/statistics/stats-2017/)
 * On a phone the whole table cannot be viewed, and we cannot swipe to the right.
   Would this be a theme issue or tablepress? This is happening on a number of tables
   on this website, and I’ll be adding a few hundred more tables to this site over
   the next month, so would like to sort this problem out.
    -  This reply was modified 8 years, 9 months ago by [Lukosius](https://wordpress.org/support/users/lukosius/).
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9602744)
 * Hi,
 * for that, you will need to add a solution for responsiveness, e.g. the `scroll`
   method from [https://tablepress.org/extensions/responsive-tables/](https://tablepress.org/extensions/responsive-tables/)
 * Regards,
    Tobias
 *  Thread Starter [Lukosius](https://wordpress.org/support/users/lukosius/)
 * (@lukosius)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9603413)
 * Excellent. That worked as well. Thanks so much!!!!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9603819)
 * Hi,
 * no problem, you are very welcome! 🙂 Good to hear that this helped!
 * Best wishes,
    Tobias
 * P.S.: In case you haven’t, please [rate TablePress](https://wordpress.org/support/plugin/tablepress/reviews/#new-post)
   here in the plugin directory. Thanks!

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

The topic ‘SUM across multiple tables’ 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/)

 * 8 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [8 years, 9 months ago](https://wordpress.org/support/topic/sum-across-multiple-tables/#post-9603819)
 * Status: resolved