
1. Re: 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.
Thom Parker Jan 18, 2018 3:18 PM (in response to abowman0123456789)1 person found this helpfulHere are some articles that cover performing calculations in Acrobat:
https://acrobatusers.com/tutorials/howtodonotsosimpleformcalculations

2. Re: 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.
abowman0123456789 Jan 19, 2018 9:49 AM (in response to Thom Parker)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"?

3. Re: 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.
Thom Parker Jan 19, 2018 11:29 AM (in response to abowman0123456789)1 person found this helpfulGood 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