Subtotals and counta I think

[Cowichandave]

Problem finding formula that works best. Column A is salesrep column B is clientID and Column I is Last Year client purchased. Columns H:2 to 6 show combined total of year sold for all.
I would to subtotal for each rep EX If select AngelaZ she has 10 clients. I would to show her stats of years sold 2015 has 2 2016 has 4 2017 has 0 2018 has 3 2019 has 1
I tried different formulas with no sucess. Help please

Book1
	A	B	C	D	E	F	G	H	I
1	..
2							2019	12
3		CLIENTS					2018	10
4		TOTAL	REP				2017	6
5		40	40				2016	9
6							2015	3
7
8		Sales	Client	Date	Date	Last Sale	Last Sale	Last Sale
9	Seq	Rep	CID	Created	Last Sold	Amount	Days	Years	Year
10	5	AngelaZ	DAV17	2015-08-31	2015-08-31	105.00	3017	8.3	2015
11	12	AngelaZ	LIS02	2015-08-27	2015-08-28	65.00	3020	8.3	2015
12	918	BobT	SEA07	2015-10-29	2015-11-09	197.40	2824	7.7	2015
13	4	AngelaZ	DAV001	2016-03-07	2016-03-11	65.00	2820	7.7	2016
14	7	AngelaZ	GER15	2016-03-14	2016-03-15	65.00	2813	7.7	2016
15	8	AngelaZ	HYD05	2016-03-14	2016-03-22	254.10	2786	7.6	2016
16	10	AngelaZ	45110	2016-03-18	2016-04-18	68.25	2817	7.7	2016
17	648	BobT	2020P	2016-10-21	2016-10-31	315.00	2813	7.7	2016
18	652	BobT	53735	2001-09-04	2016-10-31	89.25	2789	7.6	2016
19	1012	ChrisB	ALT14	2016-11-28	2016-12-07	194.25	2820	7.7	2016
20	1041	ChrisB	CPC03	2016-09-16	2016-10-01	939.75	1963	5.4	2016
21	1042	ChrisB	CYC07	2016-02-04	2016-01-15	196.88	1922	5.3	2016
22	799	BobT	INN11	2016-09-08	2017-11-27	212.10	1841	5.0	2017
23	813	BobT	LAP04	2017-05-30	2017-07-28	68.25	1679	4.6	2017
24	814	BobT	LAT03	2016-04-27	2017-07-10	409.50	1657	4.5	2017
25	824	BobT	LED18	2017-06-19	2017-06-22	157.50	702	1.9	2017
26	1005	ChrisB	AAA01	2017-02-28	2017-04-30	55.02	234	0.6	2017
27	1014	ChrisB	ARN04	2017-01-16	2017-10-26	0.00	207	0.6	2017
28	6	AngelaZ	FYI01	2015-02-18	2018-07-20	154.35	3414	9.4	2018
29	9	AngelaZ	JAC19	2018-08-09	2018-08-30	164.85	2947	8.1	2018
30	14	AngelaZ	NWS02	2016-03-16	2018-11-19	-738.99	2590	7.1	2018
31	863	BobT	NAB02PX	2003-07-08	2018-09-24	68.25	2590	7.1	2018
32	866	BobT	NEK01	2018-02-22	2018-02-22	209.95	2691	7.4	2018
33	868	BobT	NEW25	2017-07-06	2018-03-07	-151.20	2880	7.9	2018
34	1046	ChrisB	DIG03	2016-08-02	2018-05-18	0.00	2874	7.9	2018
35	1066	ChrisB	GYM01	2018-11-05	2018-11-07	0.00	2882	7.9	2018
36	1068	ChrisB	HGP01	2016-06-28	2018-08-27	410.13	2531	6.9	2018
37	1117	ChrisB	SHA29	2018-01-17	2018-01-24	197.52	2539	7.0	2018
38	3	AngelaZ	CSI07	2019-04-18	2019-04-30	99.75	2870	7.9	2019
39	841	BobT	LPS01	2017-09-25	2019-01-15	837.90	2531	6.9	2019
40	854	BobT	MIN10	2017-09-27	2019-09-16	-78.75	2590	7.1	2019
41	859	BobT	MTT01	2019-03-27	2019-03-28	68.25	2532	6.9	2019
42	867	BobT	NEW22	2016-02-26	2019-10-31	-52.50	2651	7.3	2019
43	880	BobT	OXY01	2018-06-25	2019-02-06	399.00	2775	7.6	2019
44	1003	ChrisB	76620	2000-09-30	2019-07-17	4183.25	2762	7.6	2019
45	1027	ChrisB	CANCADD	2016-04-21	2019-09-27	2633.12	2728	7.5	2019
46	1033	ChrisB	CER09	2019-02-19	2019-02-22	108.57	2804	7.7	2019
47	1055	ChrisB	ENCTEX	2019-10-03	2019-11-15	0.00	2574	7.1	2019
48	1058	ChrisB	FAR06	2015-10-06	2019-02-28	687.32	2775	7.6	2019
49	1072	ChrisB	IND11	2016-07-12	2019-11-29	230.48	2624	7.2	2019
Sheet3

Cell Formulas
Range	Formula
B5	B5	=COUNTA(B10:B25231)
C5	C5	=SUBTOTAL(3,C10:C49)
H2	H2	=COUNTIF($I$10:$I$49,"2019")
H3	H3	=COUNTIF($I$10:$I$49,"2018")
H4	H4	=COUNTIF($I$10:$I$49,"2017")
H5	H5	=COUNTIF($I$10:$I$49,"2016")
H6	H6	=COUNTIF($I$10:$I$49,"2015")
G10:G49	G10	=TODAY()-Table1[@[ Last Sold]]
H10:H49	H10	=Table1[@[ Days]]/365

 

[t0ny84]

If I understand you correctly, you want to get the total sales for an agent that were made within a time period e.g 2019 OR you want to get the total number of sales.

Total Value Of Sales - SUMIFS

=SUMIFS(sum_range, date_range, ">=01/01/YEAR", date_range, "<=12/31/YEAR", rep_range, rep_name)

=SUMIFS(Table1[Last Sold], ">=01/01/2019", Table1[Last Sold], "<=12/31/2019", Table1[Rep], "BobT")

Total Number Of Sales - COUNTIFS

=COUNTIFS(rep_range, rep_name, date_range, ">=01/01/year", date_range, "<=12/31/year")

=COUNTIFS(Table1 [Rep], "BobT", ">=01/01/2019", Table1[Last Sold], "<=12/31/2019", Table1[Rep], "BobT")