read data to obtain column counts by column

[Danny54]

How might I go about determining the following excel report

Serial	Low	Moderate	important	Critical
11112​		1​	1​
10616​	1​	1​
10859​				1​

from this sheet?

Thanks

Host	Serial	Date	Ship	New	Text
abc	11112​	1/1/2020​	1/2/2020​	11/6/2020​	Moderate
abc	11112​	1/2/2020​	1/3/2020​	11/6/2020​	Important
def	10616​	1/25/2020​	1/26/2020​	11/6/2020​	Moderate
def	10616​	1/26/2020​	1/27/2020​	11/6/2020​	Low
jhi	10859​	1/31/2020​	2/1/2020​	11/6/2020​	Critical

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	Host	Serial	Date	Ship	New	Text		Serial	Low	Moderate	important	Critical
2	abc	11112	01/01/2020	02/01/2020	06/11/2020	Moderate		11112	0	1	1	0
3	abc	11112	02/01/2020	03/01/2020	06/11/2020	Important		10616	1	1	0	0
4	def	10616	25/01/2020	26/01/2020	06/11/2020	Moderate		10859	0	0	0	1
5	def	10616	26/01/2020	27/01/2020	06/11/2020	Low
6	jhi	10859	31/01/2020	01/02/2020	06/11/2020	Critical
Data List

Cell Formulas
Range	Formula
I2:L4	I2	=COUNTIFS($F$2:$F$6,I$1,$B$2:$B$6,$H2)

 

[Danny54]

Sweet,

thanks so much. I was thinking that I would have to code a array using vba.

 

[Fluff]

You're welcome & thanks for the feedback.