Closed Thread
Results 1 to 2 of 2

Please help with the formula to find payment documents and payment amounts

  1. #1
    Registered User
    Join Date
    07-22-2023
    Location
    Vietnam
    MS-Off Ver
    2019
    Posts
    16

    Please help with the formula to find payment documents and payment amounts

    I have 2 sheets, one sheet is generated by the software, the other sheet is the result (I need to install the formula for the input list file).
    In the software sheet, column C is the VAT invoice number, column E is the number of documents created, column K is the total amount paid by the customer including VAT.
    In the results sheet, I have the VAT invoice number in column B, column T is the number of documents created
    I need to find the formula in column S and column U in the KQ sheet, column U equal Sum from S4:S17 = 319,341,579, equal to cell J4 in phan mem do ra sheet
    Hope you can help
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,139

    Re: Please help with the formula to find payment documents and payment amounts

    Duplicate threads are not allowed.

    Thread closed. The other one remains open.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find payment documents and payment amounts
    By Hongnhung88 in forum Excel General
    Replies: 1
    Last Post: 10-10-2023, 11:13 AM
  2. Need formula that looks up with 2 criteria (payment amount & month of payment)
    By thematrix05 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2023, 02:31 PM
  3. [SOLVED] Formula to lookup payment with payment amount and date
    By thematrix05 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2023, 06:35 PM
  4. Replies: 2
    Last Post: 02-14-2021, 12:49 PM
  5. formula to subtract payment amount on monthly payment date
    By restingdonkey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2014, 03:39 PM
  6. Replies: 3
    Last Post: 07-29-2013, 11:31 AM

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