# Count if?

#### Shamas

##### Board Regular
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
ABCDEFGHI
1
2TotalF/T%NameShiftHRSWorkedCalls
3#DIV/0!
40P/T%TeamRedAgent1F/T40200
5#DIV/0!Agent2F/T40198
6Agent3P/T20102
7Agent4F/T40187
8Agent5F/T40190
9Agent6F/T40195
10
11TeamBlueAgent7P/T20113
12Agent8F/T40200
13Agent9P/T20101
14Agent10P/T2099
15Agent11F/T40185
16Agent12F/T40192
17
18TeamGreenAgent13P/T20106
19Agent14F/T40198
20Agent15P/T20103
21Agent16P/T20103
22Agent17P/T20102
23Agent18P/T20100
Sheet1

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

##### MrExcel MVP
B3:

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

B5:

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

#### Shamas

##### Board Regular
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

##### Board Regular
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?

##### MrExcel MVP
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...

Replies
20
Views
310
Replies
8
Views
259
Replies
1
Views
214
Replies
1
Views
52
Replies
7
Views
87