Count if?

[Shamas]

Hi guys how do I get it to sum how many calls full timers took in B3 and how many calls P/T took in B5 please, kinda stuck, Thanks

Stats.xls
	A	B	C	D	E	F	G	H	I
1
2	Total	F/T	%			Name	Shift	HRSWorked	Calls
3			#DIV/0!
4	0	P/T	%		TeamRed	Agent1	F/T	40	200
5			#DIV/0!			Agent2	F/T	40	198
6						Agent3	P/T	20	102
7						Agent4	F/T	40	187
8						Agent5	F/T	40	190
9						Agent6	F/T	40	195
10
11					TeamBlue	Agent7	P/T	20	113
12						Agent8	F/T	40	200
13						Agent9	P/T	20	101
14						Agent10	P/T	20	99
15						Agent11	F/T	40	185
16						Agent12	F/T	40	192
17
18					TeamGreen	Agent13	P/T	20	106
19						Agent14	F/T	40	198
20						Agent15	P/T	20	103
21						Agent16	P/T	20	103
22						Agent17	P/T	20	102
23						Agent18	P/T	20	100
Sheet1

 

[Aladin Akyurek]

B3:

=SUMIF($G$4:$G$23,B2,$I$4:$I$23)

B5:

=SUMIF($G$4:$G$23,B4,$I$4:$I$23)

 

[Shamas]

Hi, That works great! I didn't think to use the B2 I kept using "F/T".
What if now the teams were on separate sheets? How would I get it to run multiple sumif and add them up in one cell (B3)?

Thank you sooooooo much

 

[Shamas]

Hi, I worked it out by doing
B3:

=SUMIF($G$4:$G$9,B2,$I$4:$I$9)+SUMIF(G11:G16,B2,I11:I16)+SUMIF(G18:G23,B2,I18:I23)

Is that an ok way of doing it?

 

[Aladin Akyurek]

Hi, I worked it out by doing
B3:

=SUMIF($G$4:$G$9,B2,$I$4:$I$9)+SUMIF(G11:G16,B2,I11:I16)+SUMIF(G18:G23,B2,I18:I23)

Is that an ok way of doing it?

Not when the data for all teams is on the same sheet...