Consider the following snapshot of MS-Excel worksheet:
|
|
A |
B |
C |
D |
|
17 |
Day |
Quantity |
Sales Amount (Rs.) |
|
|
18 |
Monday |
1 |
234 |
|
|
19 |
Tuesday |
3 |
144 |
|
|
20 |
Wednesday |
6 |
367 |
|
|
21 |
Thursday |
5 |
674 |
|
|
22 |
Friday |
8 |
1099 |
|
|
23 |
Saturday |
3 |
233 |
|
In cell D18, the value returned by the function.
= SUMIFS (C18 ∶ C23, B18 ∶ B23, ">3", C18 ∶ C23, ">500") is ____.
**Note - In Question Paper the formula was given:- = SUMIFS (C18 ∶ C23, B18 ∶ B23, "3", C18 ∶ C23, ">500", which was wrong, so we have made some changes in question to make it correct.**
1
1466
2
2140
3
1773
4
26