matrix of COUNT IF

[apgmin]

Cell A4:A5000 has the receipt dates
In correspondence cell B4:B5000 I use the product sold vide that receipt ( Item 1 , Item 2 so on )

Now I need to populate the matrix

Cell AL4 to AL15 has the months listed ( Apr, May, Jun, Jul . . . Oct, Nov, Dec )

Cell AM3 is mentioned as Item 1, Cell AN 3 has the words Item 2 etc till Item 4

I need help so that I know how many item 1 was sold in April in cell AM4, followed by how many item 2 was sold in cell AN4

The formula should check the sale date in A4:A5000 and also check the item name in cell B4:B5000

Cell AL3, MONTH	Cell AM3, ITEM 1	Cell AN3,ITEM 2	ITEM 3	ITEM 4
Cell AL4, APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
JAN
FEB
MAR

 

[jasonb75]

Why not just use a simple pivot table? Use months (from the dates) as pivot rows and item names as pivot columns.
No mention of where to find quantity in your post, if that is in a third column then you can use sum of quantity for pivot values, or if you just want to count how many entries are listed for each item then you can use count of items instead.

Far easier and more efficient than formulas.