# Count number of products on sale on different dates throughout time.

#### bark01

##### Board Regular
Hi,

I'm trying to produce a table that shows over time the most amount of products that have been sale at any given time.

My data is arranged with Product name [column A], Sales start date in , Sales end date [C].

I'm trying to arrange the data so I have a date column, then the cell next to it shows the number of products on sale on that date.

Any help would be appreciated

thanks

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
See if you can adapt this

=COUNTIFS(B:B,"<="&D1,C:C,">="&D1)

Replies
3
Views
353
Replies
5
Views
286
Replies
1
Views
257
Replies
8
Views
999
Replies
27
Views
2K

1,221,212
Messages
6,158,562
Members
451,498
Latest member
tyshanklin1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back