+ Reply to Thread
Results 1 to 2 of 2

Sum Late Payment amount

  1. #1
    Registered User
    Join Date
    09-13-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Sum Late Payment amount

    I currently sum the total amount invoiced and the total amount paid per month. I need to add a formula to figure to out how much of the total amount paid is from old invoices, but not sure how to do this. (for ex - if an we paid $5000 this month, how much of the 5000 is from previous invoices)

    These are the current formulas I use:

    total amount invc'd = sumsifs(fees!$e$3:$e$5000,Fees!$c$3"$C$5000,">="&C5,Fees!$c$3:$c$3,"<="&D5)

    Total amount pd = sumsifs(fees!$Fees!$E$3:$e$5000,Fees!$G$3:$G$5000">="&c5,Fees!$G$3:$G$5000,"<="&d5)

    Column E is the amount invoiced
    Column C is the date invoiced
    Column G is the date pd

    C5 is the 1st day of the mth
    D5 is the last day of the mth

  2. #2
    Forum Contributor yay_excel's Avatar
    Join Date
    08-12-2011
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    190

    Re: Sum Late Payment amount

    So column C contains both a list of invoice dates and the first day of the month in C5? Please upload a sample.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1