+ Reply to Thread
Results 1 to 4 of 4

Need help for counting sales frequency with a year based on Criteria

  1. #1
    Registered User
    Join Date
    02-24-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    16

    Need help for counting sales frequency with a year based on Criteria

    Hey Guru, I need help.

    So its like this: I have a list of criteria, and I want to count how many times (per month) that criteria is sold in a year. Since it's based on months, the maximum count is 12. Thank you.

    Please check attachment.sales frequency.xlsx

  2. #2
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,013

    Re: Need help for counting sales frequency with a year based on Criteria

    Try this,
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-24-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    16

    Re: Need help for counting sales frequency with a year based on Criteria

    Quote Originally Posted by windknife View Post
    Try this,
    Please Login or Register  to view this content.
    Thank you so much!!

  4. #4
    Forum Expert
    Join Date
    04-14-2009
    Location
    Taiwan
    MS-Off Ver
    Excel 2016,2019,O365
    Posts
    2,013

    Re: Need help for counting sales frequency with a year based on Criteria

    You are welcome.
    -----------------------------------
    If that takes care of your original question, please click on "Thread Tools" from the menu link above and mark this thread as SOLVED.

+ 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: 0
    Last Post: 03-29-2022, 04:59 PM
  2. calculate reorder frequency for a product based on sales history
    By dafnamat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2019, 03:36 AM
  3. Counting frequency of several set of numbers based on previous result after each round
    By yauchildchew in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-30-2018, 04:45 AM
  4. Replies: 13
    Last Post: 04-19-2015, 11:51 PM
  5. [SOLVED] Forecasting amount across a monthly column based on frequency of sales
    By eagleadam89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2014, 10:23 AM
  6. [SOLVED] Pivot Table - Compare Current Year Sales To Previous Year Sales
    By BobAJones in forum Excel General
    Replies: 0
    Last Post: 04-18-2006, 02:10 AM
  7. [SOLVED] Counting distinct entries based on meeting month & year criteria
    By jennifer in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2006, 10:00 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