+ Reply to Thread
Results 1 to 7 of 7

Sort/total up invoices in to month...

  1. 08-24-2010, 10:39 AM #1
    Frazzfreeman
    Frazzfreeman is offline
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Midlands, UK
    MS-Off Ver
    2003
    Posts
    149

    Exclamation Sort/total up invoices in to month...

    Hello there......

    Please see the attached and i hope this makes sense???
    I have a statement i need to send out and along the bottom there are totals for 1 month over due, 2 month over due etc. What i would like to be able to do is have a formula that totals these up for me instead of doing it my self......

    I'm sure the attached will make more sense than my paragraph here!!

    regards to everyone who looks into this for me!!!

    Frazzfreeman
    Attached Files Attached Files
    Last edited by Frazzfreeman; 08-26-2010 at 03:05 AM.
    Reply With QuoteRegister To Reply
  2. 08-24-2010, 11:06 AM #2
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Sort/total up invoices in to month...

    One way perhaps:

    in A31:

    Please Login or Register  to view this content.
    in B31:

    Please Login or Register  to view this content.
    in C31:

    Please Login or Register  to view this content.
    in D31:

    Please Login or Register  to view this content.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
    Reply With QuoteRegister To Reply
  3. 08-25-2010, 02:40 AM #3
    Frazzfreeman
    Frazzfreeman is offline
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Midlands, UK
    MS-Off Ver
    2003
    Posts
    149

    Re: Sort/total up invoices in to month...

    [QUOTE=NBVC;2369602]One way perhaps:

    in A31:

    Please Login or Register  to view this content.
    in B31:

    Please Login or Register  to view this content.
    in C31:

    Please Login or Register  to view this content.
    in D31:

    Please Login or Register  to view this content.





    Thanks for the reply!!

    I did what you suggested but get a #VALUE error??? Please see attached....
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 08-25-2010, 07:13 AM #4
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Sort/total up invoices in to month...

    I neglected to mention that the invoice date (Aug 20th) should be entered as a date not a text string.
    Reply With QuoteRegister To Reply
  5. 08-25-2010, 08:02 AM #5
    Frazzfreeman
    Frazzfreeman is offline
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Midlands, UK
    MS-Off Ver
    2003
    Posts
    149

    Re: Sort/total up invoices in to month...

    Again thanks for the reply!!!

    I changed the date format but the correct values do not go to the correct field??

    I need the amount's to go to the relevant filed (1month, 2 month etc) when they go over the relevent amount of time. Anything within 31 days does not need to go A31, B31, C31 or D31 because it's not outstanding as such because it's within the 31 days...

    I'm not sure if i explained very clearly what i was after. If you could have a look at the attached
    and hopefully this time it makes more sense.......

    Much appreciated!!!!!

    Frazz Freeman
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 08-25-2010, 10:15 AM #6
    NBVC
    NBVC is offline
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Sort/total up invoices in to month...

    Is the attached correct?

    This is based on your original sample?

    Are you looking for different numbers?

    Your dates in column B seemed to be of mixed formats...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 08-26-2010, 03:02 AM #7
    Frazzfreeman
    Frazzfreeman is offline
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Midlands, UK
    MS-Off Ver
    2003
    Posts
    149

    Re: Sort/total up invoices in to month...

    That's great!!!

    Thanks for all your help.............
    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)

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