View Single Post
Old April 6th, 2011, 07:03 PM
jenawyn jenawyn is offline
Registered User
Join Date: Apr 2011
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Convert Excels formula to acrobat javascript

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

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


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


Last edited by jenawyn; April 7th, 2011 at 02:33 AM..