Count if?

Shamas

Board Regular
Joined
Aug 24, 2006
Messages
64
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
 

Some videos you may like

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.

Shamas

Board Regular
Joined
Aug 24, 2006
Messages
64
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
Joined
Aug 24, 2006
Messages
64
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
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...
 

Watch MrExcel Video

Forum statistics

Threads
1,113,920
Messages
5,545,029
Members
410,647
Latest member
bernardazar
Top