Title: Convert sum formula to code
Last modified: October 3, 2022

---

# Convert sum formula to code

 *  Resolved [janxsch](https://wordpress.org/support/users/janxsch/)
 * (@janxsch)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/)
 * how can I Convert sum formula to code

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

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/#post-16063988)
 * Hello [@janxsch](https://wordpress.org/support/users/janxsch/)
 * I’m sorry, I don’t understand your question because for summing values, you only
   should use the “+” operator: A+B+C+D, etc.
 * Best regards.
 *  Thread Starter [janxsch](https://wordpress.org/support/users/janxsch/)
 * (@janxsch)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/#post-16064001)
 * i wanna calculate with this ∑
    how can I do it?
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/#post-16064018)
 * Hello [@janxsch](https://wordpress.org/support/users/janxsch/)
 * If you want to sum an array of values, you can use the SUM operation:
 * `SUM([a,b,c,d])`
 * where a,b,c, and d, can be replaced by numbers or by the field names.
 * Best regards.
 *  Thread Starter [janxsch](https://wordpress.org/support/users/janxsch/)
 * (@janxsch)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/#post-16064122)
 * i wanna calculate this sum(n;0;4;12*500*1,05^n). how?
 *  Thread Starter [janxsch](https://wordpress.org/support/users/janxsch/)
 * (@janxsch)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/#post-16064127)
 * sum(index;lower limit;upper limit;sequence), this is the english syntax
 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/#post-16064156)
 * Hello [@janxsch](https://wordpress.org/support/users/janxsch/)
 * In this case, you must use a loop in the calculated field equation:
 *     ```
       (function(){
           var result = 0;
           for(var n = 0; n<=4; n++){
               result = SUM(result, 12*500*POW(1.05,n));
           }
           return result;
       })()
       ```
   
 * Best regards.
 *  Thread Starter [janxsch](https://wordpress.org/support/users/janxsch/)
 * (@janxsch)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/#post-16064276)
 * Thanks!!

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

The topic ‘Convert sum formula to code’ is closed to new replies.

 * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377)
 * [Calculated Fields Form](https://wordpress.org/plugins/calculated-fields-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/calculated-fields-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/calculated-fields-form/)
 * [Active Topics](https://wordpress.org/support/plugin/calculated-fields-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/calculated-fields-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/calculated-fields-form/reviews/)

 * 10 replies
 * 2 participants
 * Last reply from: [janxsch](https://wordpress.org/support/users/janxsch/)
 * Last activity: [3 years, 8 months ago](https://wordpress.org/support/topic/convert-sum-formula-to-code/#post-16064276)
 * Status: resolved