Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
G | H | I | J | K | L | M | |||
100 | 0.000 | 0.000 | 0.000 | ||||||
101 | 0.000 | 0.000 | 0.000 | ||||||
102 | 0.000 | 0.000 | 0.000 | ||||||
103 | 0.000 | 0.000 | 0.000 | ||||||
104 | 0.000 | 0.000 | 0.000 | ||||||
105 | 0.000 | 0.000 | 0.000 | ||||||
106 | #NAME? | ||||||||
Score Entry |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J100 | =SUM(E100+F100+G100+H100+I100) | |
J101 | =SUM(E101+F101+G101+H101+I101) | |
J102 | =SUM(E102+F102+G102+H102+I102) | |
J103 | =SUM(E103+F103+G103+H103+I103) | |
J104 | =SUM(E104+F104+G104+H104+I104) | |
J105 | =SUM(E105+F105+G105+H105+I105) | |
K100 | =SUM(J100/5) | |
K101 | =SUM(J101/5) | |
K102 | =SUM(J102/5) | |
K103 | =SUM(J103/5) | |
K104 | =SUM(J104/5) | |
K105 | =SUM(J105/5) | |
L100 | =MIN(E100:I100) | |
L101 | =MIN(E101:I101) | |
L102 | =MIN(E102:I102) | |
L103 | =MIN(E103:I103) | |
L104 | =MIN(E104:I104) | |
L105 | =MIN(E105:I105) | |
L106 | {=MINIFS(L5:L105,L5:L105,"<>0")} | |
Press CTRL+SHIFT+ENTER to enter array formulas. |