+ Reply to Thread
Results 1 to 5 of 5

Collect monthly sales invoices into one row for each day

  1. #1
    Registered User
    Join Date
    04-13-2021
    Location
    Syria
    MS-Off Ver
    Microsoft Office Home and Student 2021
    Posts
    81

    Collect monthly sales invoices into one row for each day

    Hello,
    I have big for monthly sales,
    Each invoice is in a separate row and each invoice has (invoice price, the invoice cost, the discount, the additional, and the invoice profit)
    My problem is that I have each invoice separately and in my case I want to group the invoices by Date to show the total amounts of the invoices on a specific date on one date and one line..
    For example, i need collect all the details of the invoices that are on 20/09/2022 with one line that is on the table on the left and so on ...
    Please look at the picture for clarity.
    Untitled.png
    There is also a problem that the date is not in the same row as the invoice details, For example, as you can see in the above picture, the invoice date is in row 2 and its details are in row 3, and so on...

    I tried to use a VLOOKUP Function, but it did not work for me because the tablet are in Arabic and they are from right to left.
    That's why I think VLOOKUP it didn't work as expected...
    I attached the file..
    Thank you in advance
    Attached Files Attached Files

  2. #2
    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,408

    Re: Collect monthly sales invoices into one row for each day

    Try

    in H2

    =SUMPRODUCT(($B$2:$B$176=$G2)*(C$3:C$177))

    copy across and down
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,091

    Re: Collect monthly sales invoices into one row for each day

    H2=SUMPRODUCT(C$2:C$177*($B$3:$B$178=$G2)), copy across to column K and down.

  4. #4
    Registered User
    Join Date
    04-13-2021
    Location
    Syria
    MS-Off Ver
    Microsoft Office Home and Student 2021
    Posts
    81

    Re: Collect monthly sales invoices into one row for each day

    Thanks you so much @JohnTopley You have solved my problem ...
    @josephteh Thanks, But i don't know why you formula give my wrong result..
    For example total Selling price for 12/09/2022 is 68 your formula give me 62..

  5. #5
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,091

    Re: Collect monthly sales invoices into one row for each day

    Oh ya.. wrong rows used.. please ignore mine. John's answer is good.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Linking Fortnighly Sales with Monthly Sales
    By leo73pk in forum Excel General
    Replies: 8
    Last Post: 04-27-2020, 12:58 PM
  2. [SOLVED] Help! Need variable daily sales targets to total monthly sales goal
    By Chronohog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2018, 02:54 PM
  3. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  4. Replies: 2
    Last Post: 10-17-2013, 11:52 AM
  5. Replies: 7
    Last Post: 07-23-2013, 07:56 AM
  6. Replies: 2
    Last Post: 06-19-2012, 10:19 AM
  7. summarize monthly sales from daily sales
    By top1 in forum Excel General
    Replies: 4
    Last Post: 01-05-2010, 11:59 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1