example-sumifs-with-dates-many-conditions.xlsx

	A	B	C	D	F	G	H	Q	T	V	W
1	Date	Good	Region	Amount		https://exceltable.com/en/excel-functions/example-sumifs-with-dates-many-conditions
2	9/21/2022	Сomputer	South	890
3	8/12/2022	Printer	West	340					Range of cells that we want to apply criteria1 against	Used to determine which cells to add. Criteria1 is applied against criteria_range1.
4	1/7/2022	Fax	North	120				Cells to add
5	5/19/2022	Telephone	North	780	From
6	11/20/2022	Fax	West	200	Good	Fax
7	10/16/2022	Telephone	South	670	Region
8	3/6/2022	Сomputer	South	1020
9	12/28/2022	Fax	West	190
10	7/23/2022	Сomputer	West	900
11	2/17/2022	Telephone	North	750				SUMIFS ( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]; ...)
12	6/5/2022	Printer	South	450
13	5/8/2022	Telephone	North	950
14
15											The additional ranges along with their associated criteria.
16
17	Total:	510
18
19
20	Date	Good	Region	Amount
21	9/21/2022	Сomputer	South	890
22	8/12/2022	Printer	West	340
23	1/7/2022	Fax	North	120
24	10/19/2022	Telephone	North	780	From	9/1/2022
25	11/20/2022	Fax	West	200	Good	Telephone
26	10/16/2022	Telephone	South	670	Region	North
27	3/6/2022	Сomputer	South	1020
28	12/28/2022	Fax	West	190
29	7/23/2022	Сomputer	West	900
30	2/17/2022	Telephone	North	750
31	6/5/2022	Printer	South	450
32	9/8/2022	Telephone	North	950
33
34	Total:	1730
35
36
37	Date	Good	Region	Amount
38	1/1/2022	Computer	South	890
39	2/1/2022	Printer	West	340
40	1/7/2022	Fax	North	120
41	10/19/2022	Telephone	North	780
42	11/20/2022	Fax	West	200	Good	Telephone	Сomputer
43	10/16/2022	Telephone	South	670
44	3/6/2022	Computer	South	1020
45	12/28/2022	Fax	West	190
46	7/23/2022	Computer	West	900
47	2/17/2022	Telephone	North	750
48	6/5/2022	Printer	South	450
49	9/8/2022	Telephone	North	950
50
51	Total:	3150
52
53
54
55	Date	Good	Region	Amount
56	1/1/2022	Computer	South	890
57	2/1/2022	Printer	West	340
58	1/7/2022	Fax	North	120
59	10/19/2022	Telephone	North	780
60	11/20/2022	Fax	West	200	Good	Telephone	Сomputer
61	10/16/2022	Telephone	South	670	Region	South	West
62	3/6/2022	Computer	South	1020
63	12/28/2022	Fax	West	190
64	7/23/2022	Computer	West	900
65	2/17/2022	Telephone	North	750
66	6/5/2022	Printer	South	450
67	9/8/2022	Telephone	North	950
68
69	Total:	670
70
71
72	Date	Good	Region	Amount
73	1/1/2022	Computer	South	890
74	2/1/2022	Printer	West	340
75	1/7/2022	Fax	North	120
76	10/19/2022	Telephone	North	780
77	11/20/2022	Fax	West	200	Good	Telephone	Сomputer
78	10/16/2022	Telephone	South	670	Region	West	South
79	3/6/2022	Computer	South	1020
80	12/28/2022	Fax	West	190
81	7/23/2022	Computer	West	900
82	2/17/2022	Telephone	North	750
83	6/5/2022	Printer	South	450
84	9/8/2022	Telephone	West	950
85
86	Total:	950
87
88
89	Date	Good	Region	Amount
90	1/1/2022	Computer	South	890
91	2/1/2022	Printer	West	340
92	1/7/2022	Fax	North	120
93	10/19/2022	Telephone	North	780
94	11/20/2022	Fax	West	200
95	10/16/2022	Telephone	South	670	Amount	>=500
96	3/6/2022	Computer	South	1020
97	12/28/2022	Fax	West	190
98	7/23/2022	Computer	West	900
99	2/17/2022	Telephone	North	750
100	6/5/2022	Printer	South	450