20 Replies Latest reply: Jul 19, 2012 6:20 AM by Rahul Lakhina RSS

    Sum Error in Charts

      hi,

       

      I have three columns..

       

       

       

      ABAmount
      10002550
      32100082
      15007890
      13008954
      25130060

       

      I need to sum up the Amount when Column A = Column B. eg: First 2 rows, 1000 is in both columns but has different adjacent values, so i have to sum up 50 + 82 and similarly Row 4 and 5, since 1300 is in both columns need to sum up, 60 + 54.  whereas row 3, is a single unique line item and that remains the same. Plz help me find the right expression.