Consider the following Ms - Excel work sheet:
|
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:
1
78000
2
76500
3
99000
4
55500