Question

b) For which criterion is COUNTIF put to use? Explain the process or syntax in MS
Excel for COUNTIF command with respect to the following MS Excel table for i)
year 2000 and ii) for years above 2000 including 2000 also.
A
B
с
1 Year
Value
10.5
2 1999
3 2000
7.2
4 2001
200
5 2002
5.4
6 2003
8.1
7 2004
9
8
Sheet1​

Answer 1

2 is the correct see ausisi