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.

  • January 18, 2018
  • 1 reply
  • 1338 views

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 has been closed for replies.

1 reply

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"?

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

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