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.

[#1]

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

[#2 · Accepted solution]

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

[#3]

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

[#4]

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