Sort and count cell based on two drop down list

[Copan1795]

Hello,

I want to count the number of time I sent someone home. based on the cell in the drop down list in A and B.I want it to sort by operator. The data willbe based on the drop down list yes or no (C32 :H32) any help would be great,thank you.

Regards,
Copan

A	B	C	D
1	Sent Home	Operator	Date
2	yes	bob	1/15/2015
3	no	jon	2/15/2015
4	yes	john	3/6/2015
5	no	mary	4/15/2015
6	no	gary	3/4/2015
7	no	gary	8/1/2015
8	no	clint	9/12/2015
9	yes	ben	3/3/2015
10	no	mike	4/6/2015
11	no	gary	9/6/2015
12	no	clint	2/3/2015
13	yes	ben	3/5/2015		<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"> </o:lock></vath></v:stroke></v:shapetype><v:shape style="width: 160pt; height: 160pt; margin-top: 9pt; margin-left: 5pt; visibility: visible; position: absolute; z-index: 1; mso-wrap-style: square; v-text-anchor: top;" id="TextBox_x0020_1" type="#_x0000_t75" o:insetmode="auto" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI +gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5 8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAAUw/X7oDAABcDgAA HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWzUV9uO2zYQfS+QfxjwqUGxvsiWb4gc JJtku0DQLNabD6ApyhZCkQpJ3/L1naFoy+s2DdL2xS82Rc4M55zh5fDV632lYCutK43OWL/TYyC1 MHmpVxn7/PThZsLAea5zroyWGTtIx17PX/zyis9WltfrUgBG0G7GM7b2vp51u06sZcVdx9RS41hh bMU9ftpVN7d8h5Er1U16vVG34qVm8zbUO+45bGz5L0IpI77I/JbrLXcYUonZeU/MUYn/HpnP9PbO 1ov6wVLm4o/tg4Uyzxgyp3mFFLFuHIhm+Nm98Fq1AfaFrcjeFAXsMzYYp1PkhsEhY8loNO5hO8ST ew8CDZJefzogA0EWvSQdpdFCrD/9IIZYv/9BFEy0SQgbZ0m6mlLU27+iTo6onzDBt2YP/RN8Mga/ x05cWNQbWDiGcJHA/wv/KXM+q63zd9JUQI2MWSl8WGV8+9H5Jo+jCcFyRpX5h1Kp8EGLV94qC1uu Mqb8MfNnVkrDLmPTNEmxDlWN1Xd6FeZ4ZhZ2wvNgYY41z2UTP8X6hvJh+ifrwNRZIBxTuumMpPn9 IlSE2M0PFHOJ/0g37mT/CX8KZTBBocqawdrYb5d9O9y7mPTXDbeSgfXq1iBaXFVcC7TPmG/KqJxf +IOSNIXaqj6VtOL2Y7AtdS41EtwLyHNZPOKo+4bV7iOogPQfqM2//D213Jca/KGWBRe4m36r9I2K 2Uh+MSB5XG3uYkC4uOCarAJ5Mf8IJWmhDNNx2HLXh4dARDyDFs+0PxzSCXF9eAhExDNs8fQH4/7o OgERiggoPQM0SSaT6wREKCKgUQsoSSZYoKtccoQiAhqfARoPB1d6JhCKCGjSAiI0V3ooEIoIaHoG aJSOr/RQIBTNjXR2u4b7POC0eIsqTvpb6pvPC9Tfxys1CEE/vycl5UOExoHY+b4XLLmTqiT1HpWi n8OOaw/egDAbaqwl6E21lBZMAb6sJNyDw8sdnKkkCn8UEZXshEg5GLyf0UFIpfCOCe3cmhpys9Og Suep9w1KiRzedu6bqcowmzPWw/IA+DSw3BvbgScMlJPs36EAA1jK53NcxMXXBxgL2sCvt4MEZr8P kpfQuaBD6vyBW05i5Ls0IoFIONF4UlAbJxf1I2rFRiEeJZY7yR/9KAtU+qhmo7gRdrUkpYhyCY8+ rBf+LiPJQbOhA5WmQGg/6RtdyFsWBSb1k/4npzC/0a1/VWpjGXWf9GYjRVs9VjT2gZ8IH+HQG6B7 8a4KJvEdSI+38+/5nwAAAP//AwBQSwMEFAAGAAgAAAAhAP3BWu/OBgAAPRwAABoAAABjbGlwYm9h cmQvdGhlbWUvdGhlbWUxLnhtbOxZT28bRRS/I/EdRntv4/+NozpV7NgNtGmj2C3qcbwe704zu7Oa GSf1DbVHJCREQVyQuHFAQKVW4lI+TaAIitSvwJuZ3fVOvCZJG4EozSHeffub9/+9ebN79dqDiKFD IiTlccerXq54iMQ+n9A46Hh3RoNL6x6SCscTzHhMOt6cSO/a5vvvXcUbPqPJmGMxGYUkIggYxXID d7xQqWRjbU36QMbyMk9IDM+mXERYwa0I1iYCH4GAiK3VKpXWWoRp7G0CR6UZ9Rn8i5XUBJ+JoWZD UIwjkH57OqU+MdjJQVUj5Fz2mECHmHU84DnhRyPyQHmIYangQcermD9vbfPqGt5IFzG1Ym1h3cD8 pevSBZODmpEpgnEutDpotK9s5/wNgKllXL/f7/WrOT8DwL4Pllpdijwbg/VqN+NZANnLZd69SrPS cPEF/vUlndvdbrfZTnWxTA3IXjaW8OuVVmOr5uANyOKbS/hGd6vXazl4A7L41hJ+cKXdarh4AwoZ jQ+W0Dqgg0HKPYdMOdspha8DfL2SwhcoyIY8u7SIKY/VqlyL8H0uBgDQQIYVjZGaJ2SKfcjJHo7G gmItAG8QXHhiSb5cImlZSPqCJqrjfZjg2CtAXj3//tXzp+jV8yfHD58dP/zp+NGj44c/Wl7Owh0c B8WFL7/97M+vP0Z/PP3m5eMvyvGyiP/1h09++fnzciBU0MLCF18++e3Zkxdfffr7d49L4FsCj4vw EY2IRLfIEdrnEdhmHONqTsbifCtGIabOChwC7xLWfRU6wFtzzMpwXeI6766A5lEGvD677+g6DMVM 0RLJN8LIAe5yzrpclDrghpZV8PBoFgflwsWsiNvH+LBMdg/HTmj7swS6ZpaUju97IXHU3GM4Vjgg MVFIP+MHhJRYd49Sx6+71Bdc8qlC9yjqYlrqkhEdO4m0WLRDI4jLvMxmCLXjm927qMtZmdXb5NBF QkFgVqL8iDDHjdfxTOGojOUIR6zo8JtYhWVKDufCL+L6UkGkA8I46k+IlGVrbguwtxD0Gxj6VWnY d9k8cpFC0YMynjcx50XkNj/ohThKyrBDGodF7AfyAFIUoz2uyuC73K0QfQ9xwPHKcN+lxAn36Y3g Dg0clRYJop/MREksrxPu5O9wzqaYmC4DLd3p1BGN/65tMwp920p417Y73hZsYmXFs3OiWa/C/Qdb 9DaexXsEqmJ5i3rXod91aO+t79Cravni+/KiFUOX1gOJnbXN5B2tHLynlLGhmjNyU5rZW8IGNBkA Ua8zB0ySH8SSEC51JYMABxcIbNYgwdVHVIXDECcwt1c9zSSQKetAooRLOC8acilvjYfZX9nTZlOf Q2znkFjt8okl1zU5O27kbIxWgTnTZoLqmsFZhdWvpEzBttcRVtVKnVla1ahmmqIjLTdZu9icy8Hl uWlAzL0Jkw2CeQi83IIjvhYN5x3MyET73cYoC4uJwkWGSIZ4QtIYabuXY1Q1QcpyZckQbYdNBn12 PMVrBWltzfYNpJ0lSEVxjRXisui9SZSyDF5ECbidLEcWF4uTxeio47WbtaaHfJx0vCkcleEySiDq Ug+TmAXwkslXwqb9qcVsqnwRzXZmmFsEVXj7Yf2+ZLDTBxIh1TaWoU0N8yhNARZrSVb/WhPcelEG lHSjs2lRX4dk+Ne0AD+6oSXTKfFVMdgFivadvU1bKZ8pIobh5AiN2UzsYwi/TlWwZ0IlvPEwHUHf wOs57W3zyG3OadEVX4oZnKVjloQ4bbe6RLNKtnDTkHIdzF1BPbCtVHdj3PlNMSV/QaYU0/h/Zore T+AVRH2iI+DDu16Bka6UjseFCjl0oSSk/kDA4GB6B2QLvOKFx5BU8GLa/ApyqH9tzVkepqzhJKn2 aYAEhf1IhYKQPWhLJvtOYVZN9y7LkqWMTEYV1JWJVXtMDgkb6R7Y0nu7h0JIddNN0jZgcCfzz71P K2gc6CGnWG9OJ8v3XlsD//TkY4sZjHL7sBloMv/nKubjwWJXtevN8mzvLRqiHyzGrEZWFSCssBW0 07J/TRXOudXajrVkca2ZKQdRXLYYiPlAlMCLJKT/wf5Hhc/sRwy9oY74PvRWBN8vNDNIG8jqS3bw QLpBWuIYBidLtMmkWVnXpqOT9lq2WV/wpJvLPeFsrdlZ4n1OZ+fDmSvOqcWLdHbqYcfXlrbS1RDZ kyUKpGl2kDGBKfuYtYsTNA6qHQ8+KEGgH8AVfJLygFbTtJqmwRV8Z4JhyX4c6njpRUaB55aSY+oZ pZ5hGhmlkVGaGQWGs/QzTEZpQafSX07gy53+8VD2kQQmuPSjStZUnS9+m38BAAD//wMAUEsDBBQA BgAIAAAAIQCcZkZBuwAAACQBAAAqAAAAY2xpcGJvYXJkL2RyYXdpbmdzL19yZWxzL2RyYXdpbmcx LnhtbC5yZWxzhI/NCsIwEITvgu8Q9m7SehCRJr2I0KvUBwjJNi02PyRR7Nsb6EVB8LIws+w3s037 sjN5YkyTdxxqWgFBp7yenOFw6y+7I5CUpdNy9g45LJigFdtNc8VZ5nKUxikkUigucRhzDifGkhrR ykR9QFc2g49W5iKjYUGquzTI9lV1YPGTAeKLSTrNIXa6BtIvoST/Z/thmBSevXpYdPlHBMulFxag jAYzB0pXZ501LV2BiYZ9/SbeAAAA//8DAFBLAQItABQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAA AAAAAAAAAAAAAAAAAABbQ29udGVudF9UeXBlc10ueG1sUEsBAi0AFAAGAAgAAAAhAK0wP/HBAAAA MgEAAAsAAAAAAAAAAAAAAAAANgEAAF9yZWxzLy5yZWxzUEsBAi0AFAAGAAgAAAAhAAFMP1+6AwAA XA4AAB8AAAAAAAAAAAAAAAAAIAIAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWxQSwEC LQAUAAYACAAAACEA/cFa784GAAA9HAAAGgAAAAAAAAAAAAAAAAAXBgAAY2xpcGJvYXJkL3RoZW1l L3RoZW1lMS54bWxQSwECLQAUAAYACAAAACEAnGZGQbsAAAAkAQAAKgAAAAAAAAAAAAAAAAAdDQAA Y2xpcGJvYXJkL2RyYXdpbmdzL19yZWxzL2RyYXdpbmcxLnhtbC5yZWxzUEsFBgAAAAAFAAUAZwEA ACAOAAAAAA== " o:spid="_x0000_s1026"> <v:imagedata o:title="" src="file:///C:\Users\CHOLLO~1\AppData\Local\Temp\msohtmlclip1\01\clip_image001.png"> <o:lock aspectratio="f" v:ext="edit"> <x:clientdata ObjectType="Pict"> <x:sizewithcells> <x:cf>Bitmap</x:cf> <x:autopict> </x:autopict></x:sizewithcells></x:clientdata> </o:lock></v:imagedata></v:shape>
14	no	mary	4/6/2015
15	no	gary	5/9/2015
16	no	clint	6/1/2015
17	no	gary	7/8/2015
18	no	clint	8/30/2015
19	yes	ben	9/20/2015
20	no	mike	10/11/2015
21	no	gary	11/15/2015
22	no	clint	12/2/2015
23	yes	ben	11/6/2015
24	no	mary	1/5/2015
25	no	gary	2/25/2015
26	no	clint	3/21/2015
27	yes	ben	4/24/2015
28	no	mike	6/22/2015
29
30
31		john	mary	gary	clint	ben	mike
32	Total days sent home
33
34

<colgroup><col style="width: 48pt;" width="64"> <col style="width: 80pt; mso-width-source: userset; mso-width-alt: 3700;" width="106"> <col style="width: 58pt; mso-width-source: userset; mso-width-alt: 2676;" span="2" width="77"> <col style="width: 48pt;" span="5" width="64"> <tbody>
</tbody>

 

[portews]

Try this. Countifs lets you have multiple ranges and multiple criteria. Paste it under john in cell B32 and drag it across.

=COUNTIFS($A$2:$A$28,"yes",$B$2:$B$28,B$31)

 

[Copan1795]

Cool it worked and i added to it.

Thank you
Copan