Model count by month

[carjockey]

Hello Everyone! Thank you in advance for your help. I manage an inventory and I want to count the number of models that are arriving in the future by the month they are scheduled to arrive:

And have the output look like this:

with the counting formula in cells B3:E7
I am having trouble figuring out how to sum the models by the month they are due to arrive.
Many Thanks,
Jack

 

[lrobbo314]

Just make a pivot table out of it with 'arrival date' in the columns, 'model' in the rows, and 'model' in the values.

MXL20201209 Sequence.xlsm
	A	B	C	D	E	F	G	H	I	J	K
3	Count of Model	Column Labels
4	Row Labels	Jan	Feb	Mar	May	Jun	Jul	Oct	Nov	Dec	Grand Total
5	model 1		1	1		2		1	1		6
6	model 2	2						1		1	4
7	model 3		1		1		1				3
8	model 4		1		1						2
9	model 5	1									1
10	Grand Total	3	3	1	2	2	1	2	1	1	16
Sheet8

 

[carjockey]

Just make a pivot table out of it with 'arrival date' in the columns, 'model' in the rows, and 'model' in the values.

MXL20201209 Sequence.xlsm
	A	B	C	D	E	F	G	H	I	J	K
3	Count of Model	Column Labels
4	Row Labels	Jan	Feb	Mar	May	Jun	Jul	Oct	Nov	Dec	Grand Total
5	model 1		1	1		2		1	1		6
6	model 2	2						1		1	4
7	model 3		1		1		1				3
8	model 4		1		1						2
9	model 5	1									1
10	Grand Total	3	3	1	2	2	1	2	1	1	16
Sheet8

Just make a pivot table out of it with 'arrival date' in the columns, 'model' in the rows, and 'model' in the values.

MXL20201209 Sequence.xlsm
	A	B	C	D	E	F	G	H	I	J	K
3	Count of Model	Column Labels
4	Row Labels	Jan	Feb	Mar	May	Jun	Jul	Oct	Nov	Dec	Grand Total
5	model 1		1	1		2		1	1		6
6	model 2	2						1		1	4
7	model 3		1		1		1				3
8	model 4		1		1						2
9	model 5	1									1
10	Grand Total	3	3	1	2	2	1	2	1	1	16
Sheet8

@lrobbo314
Thank you for your response. I don't know pivot table well, am willing to learn. Update: important to the solution is that is can be "always on" so that it calculates no matter the length of the list of data and that it runs without any input when the output is needed. Will a pivot table do that, or does it need to be "run" each time there is new data?