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
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

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,209
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...
 

Forum statistics

Threads
1,140,944
Messages
5,703,312
Members
421,290
Latest member
james90

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top