S/N NAME MATH CRE KISW ENG

1 FAITH 50 70 89 45
2 NICHOLAS 53 71 86 49
3 AMOS 56 72 83 53
4 MERCY 59 73 80 57
5 62 74 77 61

6 65 75 74 65
7 68 76 71 69
8 71 77 68 73
9 74 78 65 77
10 77 79 62 81
11
12
13
14
15
16
17
18
19
20
MOGOGOSIEK
TOWN
S/N NAME MATHS ENG KISW BIO CRE TOTAL AVERAGE MIN MAX IF
1 FAITH 56 46 65 17 78 262 52.4 17 78 AVERAGE B 1000
2 AGNES 58 47 66 20 75 266 53.2 20 75 AVERAGE B
3 NICHO 60 48 67 23 72 270 54 23 72 AVERAGE B 10000
4 MARTO 62 49 68 26 69 274 54.8 26 69 AVERAGE B 20000
5 PETAA 64 50 69 29 66 278 55.6 29 69 AVERAGE B 30000
6 DENIS 66 51 70 32 63 282 56.4 32 70 GOOD B
7 CHEMUTAI 68 52 71 35 60 286 57.2 35 71 GOOD B
8 ARON 70 53 72 38 57 290 58 38 72 GOOD B
9 JUDY 72 54 73 41 54 294 58.8 41 73 GOOD A
10 EDITH 74 55 74 44 51 298 59.6 44 74 GOOD A

IF
SUMIF SUM IFS
COUNT
COUNTA 260-270 C Above 280 marks good
COUNT IF 271-280 C+ below 280 average
AVERAGE IF 281-290 B
291-300 A
 20

500 9500
1000 19000
1500 28500
 SHOP MATATU CLINIC KINYOZI TOTAL TAX
JAN 4,000 450 2,548 1,240 8,238 164.8
FEB 3,200 5,400 450 2,000 11,050 221.0
MAR 5,800 870 3,650 3,200 13,520 270.4
APR 6,500 6,900 5,470 1,023 19,893 397.9
MAY 500 5,870 6,500 1,450 14,320 286.4
JUNE 600 369 548 8,703 10,220 204.4
TOTAL 20,600 19,859 19,166 17,616 77,241 1,544.8
AVERAGE MAX MIN
4,000.0 450.0 8,073.2
5,400.0 450.0 10,829.0
5,800.0 870.0 13,249.6
6,900.0 1,023.0 19,495.1
6,500.0 500.0 14,033.6
8,703.0 369.0 10,015.6
75,696.2

4973.25

11655