+ Reply to Thread
Results 1 to 3 of 3

Formula for running balance based on i.d number

  1. 07-12-2021, 04:12 PM #1
    sunboy
    sunboy is offline
    Forum Contributor
    Join Date
    07-06-2020
    Location
    zimbabwe
    MS-Off Ver
    Excel 365
    Posts
    470

    Formula for running balance based on i.d number

    Hi

    I'm kindly asking for excel formula for running balance based on I.D number as shown on the desired outcome.

    Thank you.

    Regards,

    Sunboy
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-12-2021, 04:19 PM #2
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,215

    Re: Formula for running balance based on i.d number

    Try

    =SUMIF($A$5:A5,A5,$F$5:F5)-SUMIF($A$5:A5,A5,$G$5:G5)
    Reply With QuoteRegister To Reply
  3. 07-12-2021, 04:38 PM #3
    sunboy
    sunboy is offline
    Forum Contributor
    Join Date
    07-06-2020
    Location
    zimbabwe
    MS-Off Ver
    Excel 365
    Posts
    470

    Re: Formula for running balance based on i.d number

    Hi John Topley

    Thank you for the amazing formula.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Running Balance based on customer code
    By sunboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2020, 04:46 AM
  2. Running balance formula in filter mode
    By abid.ratnani in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-13-2016, 01:56 PM
  3. IF function for running balance that wont show starting balance in all cells
    By Heather T in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-11-2015, 03:15 PM
  4. running balance formula
    By wacky60 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-06-2011, 01:58 PM
  5. Running Balance Payment Formula
    By Hook27 in forum Excel General
    Replies: 5
    Last Post: 08-24-2008, 09:07 AM
  6. [SOLVED] rent received/balance owed/running balance spreadsheet
    By Quickbooks dummy in forum Excel General
    Replies: 1
    Last Post: 01-02-2006, 03:40 PM
  7. Creating a running balance formula
    By mm22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-20-2005, 06:04 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1