Spreadsheet: 780474d1652465854-can-you-solve-that-formulas-assignment-2
Sheet: DSUM DCOUNT DAVERAGE

Order No | Product Name | Vendor | Region | Number of Sales | Customer ID | Date | Amount
1 | Phone | Elif | Marmara | 1 | A100 | 2020-03-02 00:00:00 | 2400 |  | Product Name | Total
2 | TV | Ahmet | Marmara | 2 | A104 | 2020-03-02 00:00:00 | 4800 |  | TV
3 | Tablet | Alper | Ege | 1 | A105 | 2020-03-03 00:00:00 | 3800
4 | Phone | Ahmet | Marmara | 1 | A108 | 2020-03-03 00:00:00 | 1900 |  | Calculate the total amount of the desired products with the DSUM formula
5 | [NAME] | Elif | Marmara | 1 | A109 | 2020-03-03 00:00:00 | 300
6 | Keyboard | Alper | Ege | 2 | A103 | 2020-03-05 00:00:00 | 400
7 | TV | Mehmet | [NAME] | 1 | A106 | 2020-03-07 00:00:00 | 3600
8 | Phone | Kaan | İç Anadolu | 3 | A107 | 2020-03-09 00:00:00 | 3600 |  | Product Name | how many times has it been sold
9 | Phone | Selin | Akdeniz | 2 | A102 | 2020-03-11 00:00:00 | 4200 |  | Screen
10 | TV | Alper | Ege | 2 | A105 | 2020-03-15 00:00:00 | 9600
11 | Tablet | Elif | Marmara | 2 | A100 | 2020-03-19 00:00:00 | 7800 |  | Calculate how many times the desired products are sold with the DCOUNT formula
12 | Screen | Alper | Ege | 1 | A105 | 2020-03-22 00:00:00 | 2400
13 | Screen | Ahmet | Marmara | 1 | A104 | 2020-03-27 00:00:00 | 2600
14 | Smart watch | Selin | Akdeniz | 1 | A102 | 2020-04-04 00:00:00 | 1600
15 | [NAME] | Recep | Karadeniz | 2 | A103 | 2020-04-07 00:00:00 | 600 |  | Product Name | Average
16 | Phone | Elif | Marmara | 1 | A104 | 2020-04-08 00:00:00 | 1900 |  | Phone
17 | Tablet | Ahmet | Marmara | 2 | A109 | 2020-04-15 00:00:00 | 2700
18 | Phone | Kaan | İç Anadolu | 3 | A107 | 2020-04-17 00:00:00 | 6600 |  | Calculate average of the sale amount of the desired products  with the DAVERAGE formula
19 | [NAME] | Mehmet | [NAME] | 2 | A106 | 2020-04-18 00:00:00 | 600
20 | Phone | Elif | Marmara | 4 | A109 | 2020-04-24 00:00:00 | 5600
21 | TV | Alper | Ege | 3 | A105 | 2020-04-29 00:00:00 | 9800
22 | Screen | Alper | Ege | 2 | A105 | 2020-05-01 00:00:00 | 4400
23 | Phone | Ahmet | Marmara | 1 | A100 | 2020-05-04 00:00:00 | 2100
24 | Tablet | Mehmet | [NAME] | 1 | A106 | 2020-05-06 00:00:00 | 3300
25 | [NAME] | Kaan | İç Anadolu | 2 | A107 | 2020-05-12 00:00:00 | 500
26 | Keyboard | Recep | Karadeniz | 5 | A103 | 2020-05-14 00:00:00 | 1000
27 | Tablet | Elif | Marmara | 2 | A109 | 2020-05-17 00:00:00 | 4400
28 | Keyboard | Selin | Akdeniz | 3 | A102 | 2020-05-19 00:00:00 | 600
29 | TV | Alper | Ege | 1 | A105 | 2020-05-22 00:00:00 | 4000
30 | Smart watch | Selin | Akdeniz | 2 | A102 | 2020-05-22 00:00:00 | 2600
31 | Phone | Mehmet | [NAME] | 3 | A106 | 2020-05-24 00:00:00 | 3700
32 | Smart watch | Elif | Marmara | 6 | A109 | 2020-05-25 00:00:00 | 7200
33 | Screen | Ahmet | Marmara | 4 | A104 | 2020-05-26 00:00:00 | 9600
34 | Phone | Kaan | İç Anadolu | 4 | A107 | 2020-05-27 00:00:00 | 8700
35 | [NAME] | Recep | Karadeniz | 3 | A103 | 2020-05-28 00:00:00 | 900
36 | Tablet | Alper | Ege | 4 | A105 | 2020-05-29 00:00:00 | 12400
37 | TV | Kaan | İç Anadolu | 2 | A107 | 2020-06-01 00:00:00 | 4500
38 | [NAME] | Alper | Ege | 3 | A105 | 2020-06-01 00:00:00 | 600
39 | TV | Mehmet | [NAME] | 4 | A106 | 2020-06-01 00:00:00 | 8200
40 | Screen | Kaan | İç Anadolu | 2 | A107 | 2020-06-01 00:00:00 | 5900
41 | Smart watch | Selin | Akdeniz | 4 | A102 | 2020-06-01 00:00:00 | 4800
42 | Phone | Elif | Marmara | 5 | A100 | 2020-06-01 00:00:00 | 10000
43 | Keyboard | Recep | Karadeniz | 4 | A103 | 2020-06-01 00:00:00 | 800
44 | Screen | Ahmet | Marmara | 5 | A104 | 2020-06-01 00:00:00 | 14600
45 | Phone | Ahmet | Marmara | 2 | A100 | 2020-06-02 00:00:00 | 3600
46 | Tablet | Mehmet | [NAME] | 3 | A106 | 2020-06-02 00:00:00 | 4800
47 | [NAME] | Kaan | İç Anadolu | 3 | A107 | 2020-06-03 00:00:00 | 900
48 | TV | Selin | Akdeniz | 2 | A102 | 2020-06-05 00:00:00 | 4000
49 | TV | Recep | Karadeniz | 3 | A103 | 2020-06-06 00:00:00 | 9600
50 | TV | Ahmet | Marmara | 4 | A100 | 2020-06-08 00:00:00 | 12400
51 | Screen | Elif | Marmara | 6 | A100 | 2020-06-10 00:00:00 | 12000
52 | TV | Alper | Ege | 4 | A105 | 2020-06-12 00:00:00 | 8800
53 | [NAME] | Recep | Karadeniz | 4 | A103 | 2020-06-14 00:00:00 | 1600
54 | Keyboard | Alper | Ege | 3 | A103 | 2020-06-17 00:00:00 | 1200
55 | Smart watch | Selin | Akdeniz | 5 | A102 | 2020-06-19 00:00:00 | 5000
56 | Smart watch | Selin | Akdeniz | 2 | A102 | 2020-06-22 00:00:00 | 3000
57 | Tablet | Ahmet | Marmara | 3 | A109 | 2020-06-24 00:00:00 | 6900
58 | Keyboard | Selin | Akdeniz | 4 | A102 | 2020-06-26 00:00:00 | 1600
59 | Tablet | Ahmet | Marmara | 5 | A100 | 2020-07-01 00:00:00 | 12000
60 | Tablet | Alper | Ege | 5 | A105 | 2020-07-07 00:00:00 | 15000
61 | Screen | Elif | Marmara | 7 | A104 | 2020-07-09 00:00:00 | 21000
62 | Screen | Kaan | İç Anadolu | 1 | A107 | 2020-07-12 00:00:00 | 3000
63 | Smart watch | Selin | Akdeniz | 3 | A102 | 2020-07-14 00:00:00 | 3600
64 | TV | Alper | Ege | 1 | A105 | 2020-07-17 00:00:00 | 4000
65 | [NAME] | Mehmet | [NAME] | 5 | A106 | 2020-07-22 00:00:00 | 1000
66 | Keyboard | Recep | Karadeniz | 2 | A103 | 2020-07-29 00:00:00 | 2000
67 | [NAME] | Elif | Marmara | 5 | A109 | 2020-08-01 00:00:00 | 1500
68 | [NAME] | Alper | Ege | 4 | A105 | 2020-08-01 00:00:00 | 800
69 | Tablet | Elif | Marmara | 2 | A104 | 2020-08-04 00:00:00 | 4000
70 | TV | Ahmet | Marmara | 1 | A100 | 2020-08-09 00:00:00 | 3900
71 | TV | Recep | Karadeniz | 1 | A103 | 2020-08-12 00:00:00 | 2900
72 | Smart watch | Elif | Marmara | 2 | A109 | 2020-08-16 00:00:00 | 2400
73 | Smart watch | Alper | Ege | 3 | A105 | 2020-08-22 00:00:00 | 3600
74 | [NAME] | Alper | Ege | 3 | A105 | 2020-09-01 00:00:00 | 900
75 | Smart watch | Selin | Akdeniz | 2 | A102 | 2020-09-04 00:00:00 | 2700
76 | Screen | Alper | Ege | 1 | A105 | 2020-09-12 00:00:00 | 2200
77 | Tablet | Ahmet | Marmara | 4 | A100 | 2020-09-15 00:00:00 | 10000
78 | Phone | Kaan | İç Anadolu | 7 | A107 | 2020-09-28 00:00:00 | 14000
79 | Screen | Ahmet | Marmara | 2 | A104 | 2020-10-10 00:00:00 | 5200
80 | Tablet | Alper | Ege | 4 | A105 | 2020-10-15 00:00:00 | 12000
81 | [NAME] | Mehmet | [NAME] | 4 | A106 | 2020-10-16 00:00:00 | 1200
82 | TV | Recep | Karadeniz | 1 | A103 | 2020-10-24 00:00:00 | 3000
83 | Phone | Elif | Marmara | 6 | A100 | 2020-11-02 00:00:00 | 15000
84 | Tablet | Alper | Ege | 5 | A105 | 2020-11-03 00:00:00 | 11000
85 | Keyboard | Recep | Karadeniz | 3 | A103 | 2020-11-12 00:00:00 | 600
86 | Keyboard | Selin | Akdeniz | 5 | A102 | 2020-11-16 00:00:00 | 1000
87 | TV | Recep | Karadeniz | 1 | A103 | 2020-11-18 00:00:00 | 4200
88 | TV | Recep | Karadeniz | 5 | A103 | 2020-11-19 00:00:00 | 20000
89 | Smart watch | Alper | Ege | 2 | A105 | 2020-11-20 00:00:00 | 2400
90 | Screen | Kaan | İç Anadolu | 5 | A107 | 2020-11-24 00:00:00 | 11000
91 | TV | Elif | Marmara | 5 | A100 | 2020-12-01 00:00:00 | 10000
92 | Keyboard | Selin | Akdeniz | 7 | A102 | 2020-12-01 00:00:00 | 1400
93 | [NAME] | Recep | Karadeniz | 3 | A103 | 2020-12-04 00:00:00 | 900
94 | TV | Alper | Ege | 4 | A105 | 2020-12-12 00:00:00 | 8000
95 | Tablet | Alper | Ege | 1 | A105 | 2020-12-14 00:00:00 | 2100
96 | TV | Recep | Karadeniz | 1 | A103 | 2020-12-17 00:00:00 | 4000
97 | Smart watch | Selin | Akdeniz | 2 | A102 | 2020-12-19 00:00:00 | 3000
98 | Keyboard | Selin | Akdeniz | 1 | A102 | 2020-12-22 00:00:00 | 200
99 | Tablet | Alper | Ege | 3 | A105 | 2020-12-24 00:00:00 | 6000
100 | [NAME] | Elif | Marmara | 1 | A100 | 2020-12-27 00:00:00 | 300