Subtotal count multiple filter items

[Cowichandave]

This is a list of sales reps Col B and clients Col C and Year last Sold Columns F 2 to 6 and H 2 to 6 formula shows total for each year.
I have tried to come with a formula that would populate the year last sold for each sales rep. EX: if I select AngelaZ with 18 clients, I would like to see
her stats as 2015 as 2 2016 as 8 2018 as 3 2019 as 2 2022 as 2023 as 2 and so on for each client.

Book1
	A
1	..
Sheet1

 

[Peter_SSs]

Duplicate to: Subtotals and counta I think

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.