Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Formula to compute net amount per control

    I need to compute the net amount in Col I based on unique controls in Col E and the nett amounts of the debit values less the credit values

    I have used a simple formula to do this, but need a proper formula to compute the difference between the debit and credit values for each unique control


    Your assistance is most appreciated
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi Howard

    ..assuming the column [E] controls are in sorted order, you can use this formula (copied down) in column [I]:
    =IF(E2=E3,"",SUMIF(E$1:E2,E2,F$1:F2)-SUMIF(E$1:E2,E2,G$1:G2))
    see attached file.

    Note: In your example, the value in cell [I4] for control 12/0010 was missing.

    zeddy
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Zeddy

    Thanks for the help, much appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •