Sort and count cell based on two drop down list

C

Copan1795

New Member
Joined
Mar 20, 2015
Messages
43
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


[TABLE="width: 484"]
<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>[TR]
[TD="class: xl77, width: 64, bgcolor: transparent"]A[/TD]
[TD="class: xl77, width: 106, bgcolor: transparent"]B[/TD]
[TD="class: xl77, width: 77, bgcolor: transparent"]C[/TD]
[TD="class: xl77, width: 77, bgcolor: transparent"]D[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl66, bgcolor: transparent"]Sent Home[/TD]
[TD="class: xl65, bgcolor: transparent"]Operator[/TD]
[TD="class: xl72, bgcolor: transparent"]Date[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl71, bgcolor: transparent"]yes[/TD]
[TD="class: xl70, bgcolor: transparent"]bob[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]1/15/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]jon[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]2/15/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl71, bgcolor: transparent"]yes[/TD]
[TD="class: xl70, bgcolor: transparent"]john [/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]3/6/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]mary[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]4/15/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl71, bgcolor: transparent"]no[/TD]
[TD="class: xl70, bgcolor: transparent"]gary[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]3/4/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl71, bgcolor: transparent"]no[/TD]
[TD="class: xl70, bgcolor: transparent"]gary[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]8/1/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]clint[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]9/12/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl71, bgcolor: transparent"]yes[/TD]
[TD="class: xl70, bgcolor: transparent"]ben[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]3/3/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]mike[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]4/6/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]11[/TD]
[TD="class: xl71, bgcolor: transparent"]no[/TD]
[TD="class: xl70, bgcolor: transparent"]gary[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]9/6/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]12[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]clint[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]2/3/2015[/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl71, bgcolor: transparent"]yes[/TD]
[TD="class: xl70, bgcolor: transparent"]ben[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]3/5/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="width: 256, bgcolor: transparent, colspan: 4"]<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="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> <v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"> </o:lock></v:path></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>[/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]14[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]mary[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]4/6/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]15[/TD]
[TD="class: xl71, bgcolor: transparent"]no[/TD]
[TD="class: xl70, bgcolor: transparent"]gary[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]5/9/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]16[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]clint[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]6/1/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]17[/TD]
[TD="class: xl71, bgcolor: transparent"]no[/TD]
[TD="class: xl70, bgcolor: transparent"]gary[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]7/8/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]18[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]clint[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]8/30/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: transparent, align: right"]19[/TD]
[TD="class: xl71, bgcolor: transparent"]yes[/TD]
[TD="class: xl70, bgcolor: transparent"]ben[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]9/20/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]20[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]mike[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]10/11/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]21[/TD]
[TD="class: xl71, bgcolor: transparent"]no[/TD]
[TD="class: xl70, bgcolor: transparent"]gary[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]11/15/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]22[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]clint[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]12/2/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]23[/TD]
[TD="class: xl71, bgcolor: transparent"]yes[/TD]
[TD="class: xl70, bgcolor: transparent"]ben[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]11/6/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]24[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="class: xl73, bgcolor: transparent"]mary[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]1/5/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]25[/TD]
[TD="class: xl71, bgcolor: transparent"]no[/TD]
[TD="class: xl70, bgcolor: transparent"]gary[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]2/25/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]26[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]clint[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]3/21/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]27[/TD]
[TD="class: xl71, bgcolor: transparent"]yes[/TD]
[TD="class: xl70, bgcolor: transparent"]ben[/TD]
[TD="class: xl75, bgcolor: transparent, align: right"]4/24/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]28[/TD]
[TD="class: xl68, bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]mike[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]6/22/2015[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent, align: right"]29[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent, align: right"]30[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]31[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"]john [/TD]
[TD="class: xl65, bgcolor: transparent"]mary[/TD]
[TD="class: xl72, bgcolor: transparent"]gary[/TD]
[TD="class: xl73, bgcolor: transparent"]clint[/TD]
[TD="class: xl72, bgcolor: transparent"]ben[/TD]
[TD="class: xl66, bgcolor: transparent"]mike[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent, align: right"]32[/TD]
[TD="class: xl74, width: 106, bgcolor: transparent"]Total days sent home [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, align: right"]33[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl81, bgcolor: transparent, align: right"]34[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
Try this. Countifs lets you have multiple ranges and multiple criteria. Paste it under john in cell B32 and drag it across.

Code: 
=COUNTIFS($A$2:$A$28,"yes",$B$2:$B$28,B$31)
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question Question
Return Value from range based on lowest score
Replies
4
Views
146
Eric W
Eric W
N
  • Question Question
sync data with vlookup? between two sheets.
Replies
1
Views
42
nicholag
N
A
  • Question Question
Count number of cells in range that contain non-specific text
Replies
5
Views
195
Fluff
Fluff
H
  • Question Question
Sumproduct based on drop down criteria
Replies
2
Views
217
Cubist
Cubist
Z
  • Question Question
VBA: Date Format Issues with Data Validation
Replies
3
Views
410
zero269
Z

Share this page

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
Back
Top