Title: Formulas
Last modified: August 22, 2016

---

# Formulas

 *  Resolved [zachster104](https://wordpress.org/support/users/zachster104/)
 * (@zachster104)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/formulas/)
 * I am trying to sum the column “g”. I will have values from g3 and on. I want 
   to sum g3 to infinity. I currently have values in g3,4,5. I have entered =sum(
   g3:g1000) and I get an error. Why am I getting this?
 * Here’s the page: [http://www.fxtradersclassroom.com/trade-of-the-week/](http://www.fxtradersclassroom.com/trade-of-the-week/)
 * [https://wordpress.org/plugins/tablepress/](https://wordpress.org/plugins/tablepress/)

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/formulas/#post-5531137)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * Can you please create a CSV export of this table for me? That way I can test 
   it directly. Thanks!
 * Regards,
    Tobias
 *  Thread Starter [zachster104](https://wordpress.org/support/users/zachster104/)
 * (@zachster104)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/formulas/#post-5531336)
 * how do I send it to you?
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/formulas/#post-5531363)
 * Hi,
 * you could either upload it to your site and post the link here, or email it to
   me. My address is in the main plugin file “tablepress.php”.
 * Regards,
    Tobias
 *  Thread Starter [zachster104](https://wordpress.org/support/users/zachster104/)
 * (@zachster104)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/formulas/#post-5531385)
 * its at the bottom of this page:
 * [http://www.fxtradersclassroom.com/trade-of-the-week](http://www.fxtradersclassroom.com/trade-of-the-week)
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [11 years, 5 months ago](https://wordpress.org/support/topic/formulas/#post-5531395)
 * Hi,
 * thanks for that! Are you sure that that CSV file has the exact same content as
   the on that shows the error?
 * Also, note that the cell references must use uppercase letters. Also, you can
   not reference a cell that does not exist, unfortunately.
    So, the cell content
   of the header cell with formula has to become
 *     ```
       =Results
       Total Pips:
       {sum(G3:G5)}
       ```
   
 * Regards,
    Tobias

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

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

 * 5 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [11 years, 5 months ago](https://wordpress.org/support/topic/formulas/#post-5531395)
 * Status: resolved