Consider the following MS-Excel worksheet: A B C 1 Month Number of classes…
2023
Consider the following MS-Excel worksheet:
A | B | C | |
|---|---|---|---|
1 | Month | Number of classes taught | Payments (in ₹) made @ 1500 per class |
2 | January | 20 | 30000 |
3 | February | 14 | 21000 |
4 | March | 17 | 25500 |
5 | April | 13 | 19500 |
6 | May | 12 | 18000 |
7 | June | 15 | 22500 |
The value returned by the function =SUMIFS(C2:C7, B2:B7, ">13", C2:C7, ">22500") is:
Answer: D. 55500 — CONCEPTSUMIFS adds values from a sum range only for rows that satisfy every supplied criterion. A condition written with > is strict, so a value equal to the…
- A.
78000
- B.
76500
- C.
99000
- D.
55500
Show answer & explanation
Correct answer: D
CONCEPT
SUMIFS adds values from a sum range only for rows that satisfy every supplied criterion. A condition written with > is strict, so a value equal to the boundary is excluded.
APPLICATION
Use C2:C7 as the sum range. Test each row against both B > 13 and C > 22500.
January has B = 20 and C = 30000, so its payment enters the sum.
February has B = 14 and C = 21000; the payment value is below the strict C > 22500 boundary.
March has B = 17 and C = 25500, so its payment enters the sum.
April has B = 13 and C = 19500; the class count is equal to, not greater than, the B > 13 boundary.
May has B = 12 and C = 18000; both values are below their respective boundaries.
June has B = 15 and C = 22500; the payment is equal to, not greater than, the strict C > 22500 boundary.
CROSS-CHECK
The only included payments are 30000 and 25500. Their sum is 30000 + 25500 = 55500.
Therefore, the function returns 55500.