sumif function blog post data

	A	B	C	D	E	F	H	I	J	L	M	N	O	P	Q
1		Name	Product	Quantity	Price/unit	Total	Particulars	Results	Formula used
2	Central	Jones	Pencil	10	199.00%	19.9	Using Sumif formula	424.15	=sum(C2:C30,"Pencil")	Region	Name	Product	Quantity	Price/unit	Total
3	West	Kivell	Stand	85	$19.99		Using Sum function arrayformula	$2,736.83	=ArrayFormula(sum(if(C2:C30="Pencil",(F2:F30))))			Pen
4	Central	Howard	Pencil	1	11	11	Using Sumproduct function	2736.83	=ArrayFormula(SUMPRODUCT((C2:C30="Pencil")*(F2:F30)))
5	East	Gill	Pen	58	$19.99		Using DSUM function	$3,160.98	=dsum(A1:F30,"Total",L2:Q3)
6	East	Anderson	Stand	10	$4.99		Using Filter function	$2,736.83	=sum(filter(F2:F,C2:C="Pencil"))
7	East	Anderson	Pencil	24	$2.99		Using Query function	$2,736.83	=sum(QUERY(A:F,"select F"))
8	East	Anderson	Pencil	6	3	18
9	Central	Howard		10	$4.99	$49.9			$7,552.15
10	Central	Howard		39	$1.99
11	Central	Jones		1	$8.99	$8.99
12	West	Kivell	Pencil	80	$4.99	$399.2
13	Central	Howard	Stand	51	$1.99	$101.49
14	West	Parent	Stand	10	$19.99	$199.9
15	Central	Jones	Pencil	15	$4.99	$74.85
16	East	Anderson	Desk	31	$125	$3,875
17	Central	Jones	Gastos diarios	46	$15.99		3	25	0
18	West	Kivell	Stand	61	$8.99
19	Central	Jones	Gastos diarios	90	$8.99	1
20	West	Parent	Gastos diarios	43	$19.99	1			19.9
21	West	Kivell	Pencil	32	$4.99	$159.68			19.9
22	West	Smith	Pencil	37	$1.29	$47.73			41
23	West	Parent	Pencil	26	$15.99	$415.74
24	East	Gill	Stand	6	$8.99	$53.94
25	West	Smith	Pencil	72	$15	$1,080
26	Central	Jones	Pencil	27	$4.99	$134.73
27	Central	Jones	Stand	5	$19.99	$99.95
28	Central	Howard	Pencil	59	$4.99	$294.41
29	East	Gill	Pencil	41	$1.99	$81.59
30	Central	Howard	Pen	85	$4.99	$424.15
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81