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
[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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

[TABLE="width: 500"]
<tbody>[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.9[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]0.6[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Grade 4[/TD]
[TD]1.0[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]