Skip to main content
Participant
January 18, 2018
Answered

I am trying to create a SUMIF formula in adobe acrobat and have no idea where to begin. The code I am working with =SUMIF($F$7:$F$28,$H30,I$7:I$28). Any help of where to begin and how to finish building the script would be great.

I am trying to create a SUMIF formula in adobe acrobat and have no idea where to begin. The code I am working with =SUMIF($F$7:$F$28,$H30,I$7:I$28). Any help of where to begin and how to finish building the script would be great.

Thank you,

Ali

This topic is closed to new replies. Start a new post to keep the conversation going.
Thom Parker
Thom ParkerCorrect answer
Community Expert
January 18, 2018

Here are some articles that cover performing calculations in Acrobat:

https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations

https://acrobatusers.com/tutorials/conditional-execution

Calculating field values and more

Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often

3 replies

Thom Parker
Community Expert
Thom ParkerCommunity ExpertCorrect answer
Community Expert
January 18, 2018
Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often
Participant
January 19, 2018

This is what I have so far:

var total = 0; 

var maxFields = 22; 

for (var i=1; i<=maxFields; i++) { 

    if (this.getField("M"+i).value==("Code1") 

          total+=Number(this.getField("TL"+i).field);  

}

event.value = total; 

"Code1" is a field within the PDF, something isn't linking. How would I get it so it SUMS all TL if M matches field "Code1"?

Translate
Thom Parker
Community Expert
Community Expert
January 19, 2018

Good try   You've got a syntax error and an incorrect property

Here's the corrected code:

var total = 0;

var maxFields = 22;

for (var i=1; i<=maxFields; i++) {

    if (this.getField("M"+i).value=="Code1")

          total+=Number(this.getField("TL"+i).value);

}

event.value = total;

To see the reported errors and debug your code you need to use the Console Window. Here's a tutorial:

https://www.youtube.com/watch?v=iuFYRYezk2g&list=PLuqLmh10M1wXmHIJDqbBWVf9jU0FAtjrU&index=4

Translate
Thom Parker - Software Developer at PDFScriptingUse the Acrobat JavaScript Reference early and often