Count IF & IFS function...help!!

[alan1988]

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

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>

 

[jproffer]

You mean this? :

Excel 2013/2016

	A	B	C	D	E
1	1	Grade 4	1		24.1
2	1	Grade 4	1
3	1	Grade 4	1
4	1	Grade 4	1
5	1	Grade 4	0.9
6	1	Grade 4	1
7	1	Grade 4	1
8	1	Grade 4	0.8
9	1	Grade 4	0.4
10	1	Grade 4	0.4
11	1	Grade 4	0.4
12	1	Grade 4	0.6
13	1	Grade 4	0.6
14	1	Grade 4	0.6
15	1	Grade 4	0.6
16	1	Grade 4	0.8
17	1	Grade 4	0.8
18	1	Grade 4	0.8
19	1	Grade 4	0.8
20	1	Grade 4	0.6
21	1	Grade 4	1
22	1	Grade 4	1
23	1	Grade 4	1
24	1	Grade 4	1
25	1	Grade 4	1
26	1	Grade 4	1
27	1	Grade 4	1
28	1	Grade 4	1
29	1	Grade 4	1

<tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E1 =SUMIF(B1:B29,"Grade 4",C1:C29) <tbody> </tbody>

<tbody>
</tbody>

I was assuming FTE was column C.

If that's not what you meant, I don't understand...they're all Grade 4, so a simple SUM(C1:C29) would do the trick, but I'm assuming that in your real data, some of them are not Grade 4...??