7 Replies Latest reply: Feb 14, 2012 5:59 AM by Celambarasan Adhimulam RSS

    How to calculate combining several columns using restrictions?

      Hi,

       

      I am trying to solve a data problem. I need to create a formula that takes the sum (based on column A) of "to X" value minus the corresponding value in "balance" for X. The similar will apply for the "to Y". Another restriction is that variables in column "C" will differ, so there must be a restriction for this as well.

       

      ABCBalanceTo XTo YTO ALLOCATE XTO ALLOCATE Y
      1XZ508.9812.41496.57
      1YZ12,334.00300.8312,033.17-195.74195.74
      2XZ492.5912.01480.58
      2YZ21,118.62515.0920,603.5334.51-34.51


      The two last columns "TO ALLOCATE X" and "TO ALLOCATE Y" shows the numbers that I would like to achieve.

       

      Can anyone please help me with this issue?

       

      Thanks,

      Johanna