Hi,
Could someone help convert the following excel formulas to acobat javascript?

=SUMIF(B2:B29,"LA",A2:A29)+SUMIF(F2:F29,"LA",E2:E2 9)

=SUMPRODUCT(--(B2:B29="CC")+(F2:F29="CC"))

Looking through fields B2 to B29 for characters LA and looking through fields A2 to A29 for a number if both are their sum with others on page two.

sumproduct sum characters CC if they exist fields B2 through to B29 and page two if they exist for a number output



It would be a great help

Cheers
Stephen