Consider the following snapshot of MS-EXCEL worksheet : A B C 1 90 70 2 60 170…
2024
Consider the following snapshot of MS-EXCEL worksheet :
A | B | C | |
1 | 90 | 70 | |
2 | 60 | 170 | |
3 | 150 | 20 | |
4 | 30 | 110 | |
5 | 50 | 40 | |
6 | 130 | 30 | |
7 |
What will be the value of the cell C1 containing the formula =SUMIF(A1:A6, ">100", B1:B6) in the above worksheet ?
- A.
90
- B.
390
- C.
50
- D.
420
Attempted by 13 students.
Show answer & explanation
Correct answer: C
The SUMIF function sums values in the range B1:B6 where the corresponding cells in A1:A6 are greater than 100. Checking column A: Row 3 has 150 and Row 6 has 130, both greater than 100. The corresponding values in column B are 20 and 30. Summing these gives 20 + 30 = 50.