Formula for # of sales orders per month

Hello,

I have question about setting up a table using either formulas or a vba macro that will break out sales numbers by quantity for a given month. These numbers will then be used to calculate discounts, but that is irrelevant. I've attached a table and will reference for my questions.

Each month I will enter the number of sales into the Sales # per month category. I'm currently using the sum function to fill the total sales so far. The columns to the right of total sales by month are what I'm struggling to figure out how to automate. The month of April for example only has 4,728 sales before reaching total sales of 100,000 and the rest of the sales for that month (50,464) are under 200,000 so they are placed in the 100K+ column. May has a split between 100K+and 200K+. These splits could happen in any month and each month could have any sales quantity. If anyone has an ideas that may help that would be amazing. I'm comfortable with writing vba code and long formulas, but I just can't wrap my head around this one. Thank you.

Edit - Added the excel file. Thanks Alan for pointing out the Manage Attachments section.

Attachment 643432

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.