+ Reply to Thread
Results 1 to 8 of 8

Debit/credit in single column

  1. 05-03-2015, 06:04 PM #1
    John PK
    John PK is offline
    Registered User
    Join Date
    05-03-2015
    Location
    US
    MS-Off Ver
    Professional Plus 2013
    Posts
    4

    Smile Debit/credit in single column

    Hey all,
    I am sure this has been asked before, but I am not sure where to look it up here.
    I am making an excel checking ledger and I need to keep the debits and credits in a single column with the balance in the next column. I just need the formula or sumifs not to sure any more been a long time since I used excel for this. The main reason to keep it in one column is I am importing it from my bank and it is in .csv and I don't want to be moving amounts around once I import them in.

    Thanks in advance for any help
    Reply With QuoteRegister To Reply
  2. 05-03-2015, 06:13 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Debit/credit in single column

    Do you want a rolling sum or simple sum? If the simple sum you could put =sum(A:A) in cell B1 assuming your values are in col A, just adjust as needed.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 05-03-2015, 06:27 PM #3
    John PK
    John PK is offline
    Registered User
    Join Date
    05-03-2015
    Location
    US
    MS-Off Ver
    Professional Plus 2013
    Posts
    4

    Re: Debit/credit in single column

    Rolling I think.

    Take balance from previous row add or subtract give balance ...and so on...
    Thanks
    Reply With QuoteRegister To Reply
  4. 05-03-2015, 06:30 PM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Debit/credit in single column

    Can you post a few rows worth of sample data and tell/show us what result you expect?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  5. 05-03-2015, 06:50 PM #5
    John PK
    John PK is offline
    Registered User
    Join Date
    05-03-2015
    Location
    US
    MS-Off Ver
    Professional Plus 2013
    Posts
    4

    Re: Debit/credit in single column

    Sure thing.
    I think I attached it
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 05-03-2015, 06:58 PM #6
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Debit/credit in single column

    Like this...

    Data Range
    F
    G
    1
    DEBIT/CREDIT
    BALANCE
    2
    $447.67
    3
    ($57.60)
    $390.07
    4
    ($68.99)
    $321.08
    5
    ($124.09)
    $196.99
    6
    $258.83
    $455.82
    7
    $1,107.00
    $1,562.82
    8
    $3,407.01
    $4,969.83
    9
    ($6.17)
    $4,963.66


    This formula entered in G3 and copied down:

    =IF(COUNT(F3),G2+F3,"")
    Reply With QuoteRegister To Reply
  7. 05-03-2015, 07:03 PM #7
    John PK
    John PK is offline
    Registered User
    Join Date
    05-03-2015
    Location
    US
    MS-Off Ver
    Professional Plus 2013
    Posts
    4

    Thumbs up Re: Debit/credit in single column

    Supper!!

    Thanks :
    Reply With QuoteRegister To Reply
  8. 05-03-2015, 07:14 PM #8
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Debit/credit in single column

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
    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. Need a formula to sum credit/debit rows and place result in appropriate column
    By MARKFDU in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2014, 03:24 AM
  2. debit value plus a single / multiple credit value is zero that needs to be marked
    By kartikeypatel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-02-2013, 05:10 AM
  3. Create two line journal entry from one line, two different column for debit & credit
    By ditto135 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2011, 03:01 PM
  4. total column to minus what is in the debit Col (E) & add the Credit col (D)
    By blue elephant in forum Excel General
    Replies: 6
    Last Post: 11-09-2008, 06:09 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