8 Replies Latest reply on Apr 3, 2012 10:32 PM by George_Johnson

    Help me convert this excel formula to javascript... PLEASE!

    tetrylone1

      Hi there,


      I've been tasked with converting an excel spreadsheet to a PDF from in Livecycle designer and can't figure out the formula for a specific function. The formula in excel is:


      =SUMIF($B$39:$B$52,"1",S$39:S$52)


      The corresponding fields in Livecycle are as follows:


      B39 through B52 are Priority1.rawValue through Priority13.rawValue.


      S39 through S52 are Cost1.rawValue through Cost13.rawvalue


      I assume the field where the SUMIF is being perfomed would be this.rawValue.



      Thanks in advance for the help!