Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Project | Value | Employee1 | Employee2 | |||
2 | A | 5 | 5 | NA | |||
3 | B | 8 | 6 | 0 | |||
4 | C | 10 | NA | NA | |||
5 | D | 7 | 0 | 7 | |||
6 | E | 6 | 4 | 3 | |||
7 | |||||||
8 | Sum | 15 | 10 | ||||
9 | Sum/total | 15/26 | 10/21 | ||||
Sheet21 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D8:E8 | D8 | =SUM(D2:D6) |
D9:E9 | D9 | =D8&"/"&SUMIFS($B$2:$B$6,D$2:D$6,"<>NA") |