ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
COUNT, COUNTA, COUNTIF, COUNTIFS
3
4
5
1Open 'Sheet 2'. Write a formula in cell N4 to count the number of manufactured product units.
6
7
8
9
2Write a formula in cell N5 to count the number of different Models available in the datasheet.
10
11
12
13
3In N6, count the number of Models available for Sony.
14
15
16
17
3in N7, count the number of Models available for Sony in Japan.
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