COUNTIF with Dates Ranges

[gposton]

Hello all,

I have a list of products and dates of when they were purchased (similar to below). I would like to create a report that lists all 12 months as rows, products as columns, and do a count of the number of orders in each month. I've created the list of months using the Generate Rows tool, but I'm having trouble figuring out a way to do a "Countif" style formula to accomplish the ideal output. Thanks.

Current Dataset:

Product	Order Date
A	1/15/2017
B	4/1/2017
A	1/17/2017
F	12/3/2017
C	6/8/2017
C	6/10/2017
C	8/30/2017

Ideal Output:

Month	A	B	C	D	E	F
1/1/2017	1	0	0	0	0	0
2/1/2017	0	0	0	0	0	0
3/1/2017	0	0	0	0	0	0
4/1/2017	0	1	0	0	0	0
5/1/2017	0	0	0	0	0	0
6/1/2017	0	0	2	0	0	0
7/1/2017	1	0	0	0	0	0
8/1/2017	0	0	1	0	0	0
9/1/2017	0	0	0	0	0	0
10/1/2017	0	0	0	0	0	0
11/1/2017	0	0	0	0	0	0
12/1/2017	0	0	0	0	0	1

[alex · Accepted solution]

Here you go.

I changed the 3rd row in your current data set to read 7/17/2017 so that it matches the output in your example.

Take a look at the attached workbook. Hope this solves your issue.

[gposton]

Thank you alex!!!!