sumif-use-function-download-for-examples.xlsx

	A	B	C	E	F	G
1						Detailed description of the function:
2	Company	Product type by condition	Revenue			https://exceltable.com/en/excel-functions/sumif-use-function-download-for-examples
3	Pfizer	Soft	81,3
4	Roche	Solid	62,8
5	Sanofi	Liquid	56,1
6	Pfizer	Solid	77,8
7	Roche	Soft	34,7
8	Roche	Liquid	12,3
9	Sanofi	Soft	67,9
10	Sanofi	Solid	45,4
11	Pfizer	Liquid	32,3
12
13
14				Condition	Result
15				Sanofi	169,4
16
17
18
19	Company	Product type by condition	Revenue
20	Pfizer	Soft	81,3
21	Roche	Solid	62,8
22	Sanofi	Liquid	56,1
23	Pfizer	Solid	77,8
24	Roche	Soft	34,7
25	Roche	Liquid	12,3
26	Sanofi	Soft	67,9
27	Sanofi	Solid	45,4
28	Pfizer	Liquid	32,3
29
30
31				Exception condition:	Result
32				Sanofi	301,2
33
34
35	Company	Product type by condition	Revenue
36	Pfizer Europe	Soft	81,3
37	Roche Europe	Solid	62,8
38	Sanofi Asia	Liquid	56,1
39	Pfizer Asia	Solid	77,8
40	Roche Asia	Soft	34,7
41	Roche Europe	Liquid	12,3
42	Sanofi Europe	Soft	67,9
43	Sanofi Asia	Solid	45,4
44	Pfizer Europe	Liquid	32,3
45
46
47				Condition	Result
48				Europe	256,6
49
50
51
52	Company	Product type by condition	Revenue
53	Pfizer Europe	Soft	81,3
54	Roche Europe	Solid	62,8
55	Europe Sanofi	Liquid	56,1
56	Pfizer Europe and Asia	Solid	77,8
57	Roche Europe and Asia	Soft	34,7
58	Europe Roche	Liquid	12,3
59	Sanofi Europe and Asia	Soft	67,9
60	Sanofi Asia and Europe	Solid	45,4
61	Pfizer	Liquid	32,3
62
63
64				Condition	Result
65				Europe at the beginning	68,4
66				Europe at the end	189,5
67
68
69	Company	Product type by condition	Revenue
70	Pfizer	Soft	81,3
71	Roche Europe	Solid	62,8
72	Europe Sanofi	Liquid	56,1
73	Pfizer Europe and Asia	Solid	77,8
74	Roche Europe and Asia	Soft	34,7
75	Europe Roche	Liquid	12,3
76	Sanofi Europe and Asia	Soft	67,9
77	Sanofi Asia and Europe	Solid	45,4
78	Pfizer	Liquid	32,3
79
80
81				Condition	Result
82				6 letters	113,6
83
84
85	Company	Product type by condition	Revenue
86	Pfizer	Ointments	81,3
87	Roche	Powder	62,8
88	Sanofi	Powder	56,1
89	Sanofi	Tablets	56,8
90	Pfizer	Powder in capsules	77,8
91	Roche	Ointments	34,7
92	Roche	Powder in capsules	12,3
93	Roche	Tablets	12,6
94	Sanofi	Ointments in tubes	67,9
95	Pfizer	Tablets	78,9
96	Sanofi	Ointments in tubes	45,4
97	Pfizer	Ointments in tubes	32,3
98	Pfizer	Powder in capsules	67,9
99
100				Condition	Result