Hi, I have been ripping my hair out trying to figure out how to find a formula with the data below:
I need to show of the 29 staff who are Grade 4, what the total FTE is of anyone who is Grade 4 and the total FTE
Could someone show me what the best formula would be to calculate this?
Thanks in advance
<tbody>
</tbody>
I need to show of the 29 staff who are Grade 4, what the total FTE is of anyone who is Grade 4 and the total FTE
Could someone show me what the best formula would be to calculate this?
Thanks in advance
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 0.9 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 0.8 |
1 | Grade 4 | 0.4 |
1 | Grade 4 | 0.4 |
1 | Grade 4 | 0.4 |
1 | Grade 4 | 0.6 |
1 | Grade 4 | 0.6 |
1 | Grade 4 | 0.6 |
1 | Grade 4 | 0.6 |
1 | Grade 4 | 0.8 |
1 | Grade 4 | 0.8 |
1 | Grade 4 | 0.8 |
1 | Grade 4 | 0.8 |
1 | Grade 4 | 0.6 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
1 | Grade 4 | 1.0 |
29 |
<tbody>
</tbody>