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

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

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