Google Sheets - Functions

	A	B	C	D	E	F	G
1		Catering Invoice Sabrosa Empanadas & More 1202 Biscayne Bay Drive Orlando, FL 32804		Invoice #: 5690B
2	ITEM	QUANTITY	UNIT PRICE	LINE TOTAL	ORDERED	RECEIVED	IN TRANSIT
3	Tomatoes (case of 12)	3	$17.44	$52.32	12-Oct	15-Oct
4	Black Beans (case of 10)	5	$20.14	$100.70	12-Oct	17-Oct
5	All Purpose Flour (50 lb.)	5	$14.05	$70.25	12-Oct	14-Oct
6	Corn Meal/Maza (25 lb.)	5	$18.69	$93.45	12-Oct	15-Oct
7	Brown Rice (25 lb.)	5	$10.99	$54.95	12-Oct	15-Oct
8	Lime Juice (1 gallon)	5	$11.99	$59.95	16-Oct	20-Oct
9	Tomato Juice (case of 10)	3	$19.49	$58.47	16-Oct	19-Oct
10	Hot Sauce (1 gallon)	8	$7.35	$58.80	16-Oct	20-Oct
11	Salsa, Medium (1 gallon)	12	$8.47	$101.64	19-Oct	23-Oct
12	Olive Oil (2.5 gallon)	4	$28.69	$114.76	19-Oct	24-Oct
13			TOTAL	$765.29
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100