+ Reply to Thread
Results 1 to 5 of 5

Count the number of sales per month

  1. #1
    Registered User
    Join Date
    12-13-2023
    Location
    Jasper, AL
    MS-Off Ver
    Microsoft 365
    Posts
    26

    Count the number of sales per month

    I have attached my sample worksheet. Below is the sample of the findings I am wanting to achieve. It is also found within the sheet. The yellow block.
    I am wanted to count the number of sales booked for each month. I already have the total $ value (thank you very much).
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Count the number of sales per month

    Could use the formula bellows.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-13-2023
    Location
    Jasper, AL
    MS-Off Ver
    Microsoft 365
    Posts
    26

    Re: Count the number of sales per month

    It worked. Thank you so much for your assistants.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,887

    Re: Count the number of sales per month

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

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Count the number of sales per month

    Tks for the feedback, glad to help.

+ 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. Replies: 4
    Last Post: 04-01-2022, 10:42 PM
  2. [SOLVED] count product sales by month
    By bkjacobs in forum Excel General
    Replies: 1
    Last Post: 04-08-2021, 12:50 PM
  3. [SOLVED] calculating Dynamic current month sales and previous month sales
    By anilpatni1234 in forum Excel General
    Replies: 4
    Last Post: 07-29-2018, 11:22 PM
  4. SALES COMPARISON BY WEEK NUMBER, MONTH, QUARTER AND yEAR
    By faodavid in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-30-2017, 02:53 PM
  5. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  6. Count number of networkdays for each month in a multi month period
    By dreddster in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2013, 11:12 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