6 Replies Latest reply: Oct 30, 2012 8:55 AM by janardhan reddy RSS

    Range

    janardhan reddy

      Hi Friends ,

       

      if any one can give me an idea about this ,

       

      i need sum in between OTG50 to OTG175 , for that i tried like this. its wrong expression. cany anyone help me

       

      =RANGESUM(IF(ITEMID>='OTG50' - ITEMID<='OTG175' , LINEAMOUNT))

       

       

      Thanks

      jana