<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
p.preheader-container, li.preheader-container, div.preheader-container
{mso-style-name:preheader-container;
margin:0in;
margin-bottom:.0001pt;
mso-line-height-alt:.75pt;
font-size:1.0pt;
font-family:"Times New Roman",serif;
display:none;}
span.line
{mso-style-name:line;}
span.grabber
{mso-style-name:grabber;}
span.contact-detail
{mso-style-name:contact-detail;}
span.footer-column
{mso-style-name:footer-column;}
span.footer-mobile-hidden
{mso-style-name:footer-mobile-hidden;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Arial",sans-serif;
color:#1F497D;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:111243994;
mso-list-template-ids:-1464720980;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:250941570;
mso-list-template-ids:-177023622;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2
{mso-list-id:422798405;
mso-list-template-ids:-392402006;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l2:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l2:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3
{mso-list-id:431586299;
mso-list-template-ids:1490160256;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l3:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l3:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4
{mso-list-id:622812602;
mso-list-template-ids:-643941792;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l4:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l4:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5
{mso-list-id:722489441;
mso-list-template-ids:-1659202726;}
@list l5:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l5:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l5:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6
{mso-list-id:759713939;
mso-list-template-ids:-892804470;}
@list l6:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l6:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l6:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l6:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7
{mso-list-id:790246163;
mso-list-template-ids:1382743130;}
@list l7:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l7:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l7:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l7:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8
{mso-list-id:960304339;
mso-list-template-ids:645321802;}
@list l8:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l8:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l8:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l8:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l9
{mso-list-id:1094395006;
mso-list-template-ids:1063303340;}
@list l9:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l9:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l9:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l9:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l9:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l9:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l9:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l9:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l9:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l10
{mso-list-id:1179005096;
mso-list-template-ids:-1022316442;}
@list l10:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l10:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l10:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l10:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l10:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l10:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l10:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l10:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l10:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l11
{mso-list-id:1221407526;
mso-list-template-ids:-947989506;}
@list l11:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l11:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l11:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l11:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l11:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l11:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l11:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l11:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l11:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l12
{mso-list-id:1497114373;
mso-list-template-ids:1570789234;}
@list l12:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l12:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l12:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l12:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l12:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l12:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l12:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l12:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l12:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l13
{mso-list-id:1784302201;
mso-list-template-ids:-1997010366;}
@list l13:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l13:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l13:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l13:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l13:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l13:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l13:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l13:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l13:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l14
{mso-list-id:1822194127;
mso-list-template-ids:-1751716596;}
@list l14:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l14:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l14:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l14:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l14:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l14:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l14:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l14:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l14:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l15
{mso-list-id:2125923125;
mso-list-template-ids:1750231718;}
@list l15:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l15:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l15:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l15:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l15:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l15:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l15:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l15:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l15:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l16
{mso-list-id:2136946101;
mso-list-template-ids:1412830134;}
@list l16:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l16:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l16:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l16:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l16:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l16:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l16:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l16:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l16:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="whitesmoke" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Greetings and welcome to this week’s issue of Tech-Talk!</span><o:p></o:p></b></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<div>
<div id="preheader">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="font-size:1.0pt">o you know these Excel "Counting" formulas? <o:p></o:p></span></p>
</div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<span style="font-size:1.0pt"><img id="_x0000_i1025" src="http://r20.rs6.net/on.jsp?ca=35b5da7a-c131-4199-b5a1-871ba11898da&a=1100778316270&c=980e0ed0-0713-11e6-a7b7-d4ae528ed502&ch=981cb4d0-0713-11e6-a7b7-d4ae528ed502"><o:p></o:p></span></p>
</div>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:whitesmoke;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:459.0pt;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:11.25pt 3.75pt 11.25pt 3.75pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="background:#478CCB;padding:.75pt .75pt .75pt .75pt">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:#478CCB;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="background:white;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img width="220" id="_x0000_i1026" src="http://files.constantcontact.com/ee1208b4001/34916cb2-412f-43fa-8294-1f7ecb0e9a3d.png"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:#BFBFBF;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"> </span><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:white">Want to share Tech-Talk? Ask first. Contact
</span></b><span style="color:#333333"><a href="mailto:info@tech-talk.com" target="_blank"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:white">info@Tech-Talk.com</span></b></a>
</span><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:white">© 2019 Shared Results International</span></b><span style="color:#333333">
<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="50%" valign="top" style="width:50.0%;background:whitesmoke;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 7.5pt 7.5pt 15.0pt">
<div>
<p class="MsoNormal"><img border="0" width="270" id="_x0000_i1027" src="https://files.constantcontact.com/ee1208b4001/4fec0b02-4e14-4142-b18e-a171347a0c3b.png"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<td width="50%" valign="top" style="width:50.0%;background:whitesmoke;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 7.5pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-family:"Arial",sans-serif;color:#387B37"><o:p> </o:p></span></b></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:15.0pt;font-family:"Arial",sans-serif;color:#CF8F12">Have You Registered Yet?</span></b><b><span style="font-family:"Arial",sans-serif;color:#387B37"><o:p></o:p></span></b></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 7.5pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:13.5pt;color:#16274C">A 3-Part Webinar Series</span></b><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.5pt;color:#16274C">for</span><span style="color:#333333">
<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:13.5pt;color:#16274C">OREGON Library Staff</span></b><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.5pt;color:#16274C">(It's free!)</span><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:15.0pt;color:#3661BD">"Become a Tech Hero and a Power Communicator"</span></b><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001Xll4kKeM-_kWTdSTIJMxDQTEB7_yE52nX6gtFjZbmri7TLxSiCJlk-GYJAh1ksDzsQPTMoR_tKfKpYHW1JYEY1SccGv_wzr6u_L45mgNqD0rX9gvRMkA-C6yerJj6VNJdCxSHufFc6bkAP1GHY5Hy0Q343J6PLD4v_PAdPT7eJS1vqEuhnLX-bYej2FTq9UiIbHVbX6VQuQ=&c=1Hvl0kulQha5EmOpSTAxNlXBUdgVByUWHYfWq6TpnyeouhsV39xVTA==&ch=eFFXaLtIgrfHtbepbxKoVkx1nqF6Jc1z958tgrwfFcGEjy7QZkc7sw==" target="_blank"><b><span style="font-size:13.5pt;color:#16274C">Register
Here</span></b></a><b>!</b> <o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333"> </span><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">This Week's Topic: EXCEL / Google Sheets</span></b><span style="color:#333333">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#16274C">1. VIDEO ... </span></b><span style="color:#333333">COUNTA, COUNTIF, Count What?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#16274C">2. ARTICLE ...</span></b><b><span style="color:#333333"> </span></b><span style="color:#333333">COUNTA, COUNTIF, Count What?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#16274C">3. COMMUNICATING </span></b><span style="color:#16274C">...
</span><span style="color:#333333">Passing it on<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1028" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:white;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><a href="http://r20.rs6.net/tn.jsp?f=001Xll4kKeM-_kWTdSTIJMxDQTEB7_yE52nX6gtFjZbmri7TLxSiCJlk9nfd5K11Z5ZsKRUtiNx8vb5wow4YK6EdLbpGuwWG8PoMINnPHhhFT6ZjbVZxnJD-jU4FFIABQHH_YSGOiFlkFA2WmlYqVTeEbW9C2WdQ1frVQFsDgURUFs_Y890cwTXCI5BPhUIhYor&c=1Hvl0kulQha5EmOpSTAxNlXBUdgVByUWHYfWq6TpnyeouhsV39xVTA==&ch=eFFXaLtIgrfHtbepbxKoVkx1nqF6Jc1z958tgrwfFcGEjy7QZkc7sw=="><span style="text-decoration:none"><img border="0" width="525" id="_x0000_i1029" src="https://files.constantcontact.com/ee1208b4001/05647518-6c0b-4f57-a67c-5d09f328b318.png" alt="Counting formulas"></span></a><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.5pt;color:#111111">Photo by </span><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001Xll4kKeM-_kWTdSTIJMxDQTEB7_yE52nX6gtFjZbmri7TLxSiCJlk9nfd5K11Z5ZkdQwwoxGXYYI8R-7gnlsrlY5NY57LbMpz5aytxjWfkcxdaoVwmtMhIdhl1EZxylza3YL9Bl9sGGNQaLpe_M_2All6AnFDhf1ZobUqRSufN8-8ld3s0dV2VRZ-GQbWbukFWoSHF3LhR8g9kDNu2qqAo3oRuvAFCl8_JDA_d1wGvWpaVPEqz5DsQiuZNdYitHtdlYXu8l0mQw=&c=1Hvl0kulQha5EmOpSTAxNlXBUdgVByUWHYfWq6TpnyeouhsV39xVTA==&ch=eFFXaLtIgrfHtbepbxKoVkx1nqF6Jc1z958tgrwfFcGEjy7QZkc7sw==" target="_blank"><span style="font-size:10.5pt;color:#999999">Marco
Secchi</span></a></span><span style="font-size:10.5pt;color:#111111"> on </span><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001Xll4kKeM-_kWTdSTIJMxDQTEB7_yE52nX6gtFjZbmri7TLxSiCJlk9nfd5K11Z5Z0gRH14oeUkGKxIXz0tcmWgJB3I5deHPbJ_U1T7Z06NwBGCuBNPoviGVm2cybd1RaE3p_xJFNuyoZhOmzisTMlyeU8to3OG908G7h4jxGLWtDcFQzVfiEtCrrqPUyIs4iWpR3_lxhhLBJFbbGdoV2oO5VHaY3QrRtcdj-PBS4WCWTvktYdZJ-Jz6cbd7oJqQpnaMckT9D4YZC2H06m0XE9HvvniJmTpbZ&c=1Hvl0kulQha5EmOpSTAxNlXBUdgVByUWHYfWq6TpnyeouhsV39xVTA==&ch=eFFXaLtIgrfHtbepbxKoVkx1nqF6Jc1z958tgrwfFcGEjy7QZkc7sw==" target="_blank"><span style="font-size:10.5pt;color:#999999">Unsplash</span></a>
<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1030" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">Brought To You By
<span class="contact-detail">State Library of Oregon</span></span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;background:white;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1031" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="45%" valign="top" style="width:45.0%;background:white;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="165" id="_x0000_i1032" src="https://files.constantcontact.com/ee1208b4001/9975e68c-5234-456e-bd40-fe203e94bf80.png" alt="State of Oregon"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<td width="55%" valign="top" style="width:55.0%;background:white;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 7.5pt">
<div>
<div>
<p class="MsoNormal"><span style="color:#333333"><a href="http://r20.rs6.net/tn.jsp?f=001Xll4kKeM-_kWTdSTIJMxDQTEB7_yE52nX6gtFjZbmri7TLxSiCJlk_lagUevvbDhxWhGROChCcqtl7hXAMyC2SBIBTdyytT9_u45YSa5M4VbmM3ojLlz1sG_Sz9eXmDV-i2N6Gvq0I8VligaQqvsdSIWcOgUeFQg&c=1Hvl0kulQha5EmOpSTAxNlXBUdgVByUWHYfWq6TpnyeouhsV39xVTA==&ch=eFFXaLtIgrfHtbepbxKoVkx1nqF6Jc1z958tgrwfFcGEjy7QZkc7sw==" target="_blank"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Visit
Tech-Talk.com Database</span></b></a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="color:#333333">Username</span></b><span style="color:#333333">:
<span class="contact-detail">ORLIBTECH</span> <o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="color:#333333">Password</span></b><span style="color:#333333">:
<span class="contact-detail">ORLIBTECH</span> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="color:#333333">Questions about Tech-Talk?</span></b><span style="color:#333333"><o:p></o:p></span></p>
<p class="MsoNormal"><span class="contact-detail"><span style="color:#333333"><a href="mailto:darci.hanning@state.or.us">darci.hanning@state.or.us</a></span></span><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1033" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">EXCEL / Google Sheets – COUNTA, COUNTIF, Count What?</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><i><span style="color:#333333">Intermediate</span></i><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1034" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="266" id="_x0000_i1035" src="https://files.constantcontact.com/ee1208b4001/880749ae-7733-44ea-aa59-684f319efae9.png" alt="survey"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1036" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1037" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">I was looking at some survey results that were pulled into an Excel spreadsheet. I needed to calculate the number of people that
<i>answered </i>a question, those that left it <i>blank</i>, as well as compute results for some questions that were in
<i>text</i>, not a number. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">I use formulas all the time to add up columns/rows, compute averages, etc... but these calculations are a little different. I know that Excel is powerful, so it is just a matter of learning the correct ones.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">These functions may not be used every day, but they are very handy when you do need them.
<b>We'll call them the "Counting" formulas.</b> Let's take a look at the most common four and how you would use them.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1038" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Counting Formulas</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Excel has a set of formulas that start with "COUNT..."</span></b><span style="color:#333333"> These functions help you to automatically count the number of cells in a range that are blank, have data or contain
certain types of data.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l7 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="color:#333333">COUNT</span></b><span style="color:#333333">: Counts cells that contain
<i>numbers </i>(only numbers)<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l7 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="color:#333333">COUNTA</span></b><span style="color:#333333">: Counts cells that contain
<i>anything </i>(numbers and text)<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l7 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="color:#333333">COUNTBLANK</span></b><span style="color:#333333">: Count cells that are
<i>blank</i> (empty)<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l7 level1 lfo1">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><b><span style="color:#333333">COUNTIF</span></b><span style="color:#333333">: Counts cells that meet a
<i>specified/single criteria</i> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Now that we understand what they are and do, let's play with these formulas.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1039" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Using COUNT</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#2F2F2F">Again, COUNT tells you how many of the cells (that you specify) have
<i>numbers</i> in them (COUNTA will tell you how many cells are filled with <i>any type</i> of data).</span><span style="color:#333333">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#2F2F2F">In this example we want to<b> <i>
count </i>the cells</b> <b>that have <i>numbers</i> in them</b> - showing which people answered a question. It doesn't add them. It's looking for the number of responses.
</span><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1040" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="284" id="_x0000_i1041" src="https://files.constantcontact.com/ee1208b4001/d1b0ec1d-2f03-4a6a-af33-8813ed16c464.png" alt="count"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1042" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1043" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#2F2F2F">Since they are numbers, we can use the COUNT formula.
</span><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l12 level1 lfo2">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#2F2F2F"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#2F2F2F">First, place your cursor in the cell
<b>where you want</b> <b>the results displayed</b>. <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l9 level1 lfo3">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#2F2F2F"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#2F2F2F">In the cell (or in the formula bar at the top), type =COUNT(range of cells). In this case based on the range of cells it would be
<b>=COUNT(B2:B15)</b>. <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l3 level1 lfo4">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#2F2F2F"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#2F2F2F">Click Enter.<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">The results will be displayed. In this example, we have eight people that answered the question.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="314" id="_x0000_i1044" src="https://files.constantcontact.com/ee1208b4001/9aeeb883-9093-473e-bf22-4fd481c36108.png" alt="results"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1045" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">COUNTA</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#2F2F2F">Use COUNTA in situations where there is
<i>any type</i> of data in the cells -- like text.</span><span style="color:#333333">
<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#2F2F2F">Below in the survey results, we want to see
<b>how many people answered with each type of response</b> (Bad, Satisfactory, Good, Great).</span><span style="color:#333333">
<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1046" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="267" id="_x0000_i1047" src="https://files.constantcontact.com/ee1208b4001/c5621a86-bb28-4614-af15-b2b135b827cf.png" alt="Counta"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1048" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1049" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l15 level1 lfo5">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#2F2F2F"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#2F2F2F">First, to make it easier to view so that all of the answers are together, we sorted by answer type.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l16 level1 lfo6">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Next place your cursor in the cell where you want the results displayed. In this example, we want to see the results after each section of answers.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l2 level1 lfo7">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">In the cell (or in the formula bar at the top), type =COUNTA(range of cells). In this example, for the first set of answers for the response "Bad" -- the range of cells it would be
<b>=COUNTA(B2:B3)</b> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l14 level1 lfo8">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Hit Enter.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">After we completed the formula for the other three survey responses we have a number displayed that represents how many people responded with each answer type.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="275" id="_x0000_i1050" src="https://files.constantcontact.com/ee1208b4001/72d8d325-3b5a-40cc-ba45-62edcf8f65c5.png" alt="counta"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1051" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">COUNTBLANK</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1052" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="316" id="_x0000_i1053" src="https://files.constantcontact.com/ee1208b4001/52697f06-7f67-4d5c-bd4e-c9bfb1432157.png" alt="count"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1054" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1055" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">Using this same question example, now we want to
<b>count the <i>blank </i>cells </b>(the number of people that did <i>not </i>answer the question). <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l11 level1 lfo9">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Place your cursor in the cell where you want the results displayed.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l13 level1 lfo10">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">In the cell (or in the formula bar at the top), type =COUNTABLANK(range of cells). In this case based on the range of cells it would be
<b>=COUNTBLANK(B2:B15)</b> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l10 level1 lfo11">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Hit Enter.<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">The results will be displayed. In this example, we have six people who did NOT answer the question.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="335" id="_x0000_i1056" src="https://files.constantcontact.com/ee1208b4001/7234ed0d-25f1-4563-801d-72ee446c71fb.png"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1057" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">COUNTIF</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">The COUNTIF formula helps you to "count IF a cell meets a criteria." <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">So in our survey, we have a question with four possible answers: Bad, Satisfactory, Good and Great.
<b>We want to calculate how many of each answer was reported</b>.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">We'll start by adding the formula to the first answer, Bad. Then we can copy the formula and just replace the answer for the other three.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">In this formulas we need to not only add the function and range of cells, but the "criteria" as well (Bad, Satisfactory, Good or Great).<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1058" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="290" id="_x0000_i1059" src="https://files.constantcontact.com/ee1208b4001/cf28af05-a64b-4481-9319-069b34a1f828.png" alt="Countif"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1060" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1061" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l1 level1 lfo12">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Place your cursor in the cell where you want the results displayed.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l8 level1 lfo13">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">In the cell (or in the formula bar at the top), type =COUNTIF(range of cells, "criteria"). In this example, for "Bad" our formula would look like
<b>=COUNTIF(B2:B15,"Bad")</b> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l6 level1 lfo14">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Hit Enter.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Now we’ll simply <b>copy the formula into the other three cells and replace the criteria
</b>with Satisfactory, Good and Great.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Our results show the number of people that answered with each particular answer.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="336" id="_x0000_i1062" src="https://files.constantcontact.com/ee1208b4001/15f4454a-8793-4e3f-b512-9ae11123f6d7.png" alt="countif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1063" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Another Way to Add These “Counting” Formulas</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">If you don't remember the actual formula</span></b><span style="color:#333333">, but the "name"...<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l4 level1 lfo15">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Place your cursor in the cell where you want it displayed and in the menu go to the
<i>Formulas </i>tab, click <i>More Functions</i>, select <i>Statistical</i>, and then click one of the functions.<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="534" id="_x0000_i1064" src="https://files.constantcontact.com/ee1208b4001/53e80be7-0e6d-457f-943e-f2afef354975.png" alt="Count"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l5 level1 lfo16">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">Then in the <i>Function Arguments</i> box,
<i>Value1</i>, enter the range of cells. Then click <i>OK</i>.<o:p></o:p></span></p>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="530" id="_x0000_i1065" src="https://files.constantcontact.com/ee1208b4001/ff40a761-77f0-4f45-8b33-ef41d0f8f789.png"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal"><span style="color:#333333">Your formula results will be displayed.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:6.75pt 0in 6.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="93%" style="width:93.0%;border-collapse:collapse;min-width: 93%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1066" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="right" style="border-collapse:collapse;margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1067" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="178" id="_x0000_i1068" src="https://files.constantcontact.com/ee1208b4001/a538b7e1-6dbc-4fde-a905-bd369ebc4324.png" alt="Google Sheets"><o:p></o:p></p>
</div>
</td>
</tr>
<tr style="height:3.75pt">
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1069" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td valign="top" style="padding:0in 0in 0in 0in;height:3.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1070" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Google Sheets</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Good News! <b>If you use Google Sheets</b>, these Counting formulas work exactly the
<i>same</i>.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Follow the steps above to automatically count the number of cells in a range that are
<i>blank</i>, <i>contain data</i> or contain certain <i>types</i> of data.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">So, no matter if you are in Excel or Google Sheets, you can use these formulas to count in a number of different ways.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#3661BD">Another Idea</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">If you do this type of thing often, you may also want to consider making it simpler by creating a Pivot Table.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">(<b>See the Tech-Talk Treasure Hunt:</b><a href="http://r20.rs6.net/tn.jsp?f=001Xll4kKeM-_kWTdSTIJMxDQTEB7_yE52nX6gtFjZbmri7TLxSiCJlk9nfd5K11Z5ZtY-_ma2BWgsES5Oi3amutJSdbd_MQtJ7azjceAUpNsV733QabMuVz4IyV9BpF_IRj9saITsPtjs-4MZY_BGDscNR_wE2CxuJx54m8rCgZLNZE_i4caS53JUg3HQ6a8ZOfJSoztVJAMs=&c=1Hvl0kulQha5EmOpSTAxNlXBUdgVByUWHYfWq6TpnyeouhsV39xVTA==&ch=eFFXaLtIgrfHtbepbxKoVkx1nqF6Jc1z958tgrwfFcGEjy7QZkc7sw==" target="_blank"><b><span style="color:#3661BD">
Pivot Tables</span></b></a>.)<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 3.75pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 4.5pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1071" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" style="border-collapse:collapse;margin-right:3.5pt">
<tbody>
<tr style="height:.75pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><img border="0" width="180" id="_x0000_i1072" src="http://files.constantcontact.com/ee1208b4001/f8f1ecc8-4884-4c21-8ed0-cf647e6db944.png"><o:p></o:p></p>
</div>
</td>
<td width="15" valign="top" style="width:11.25pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="15" height="1" id="_x0000_i1073" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
<tr style="height:.75pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="1" height="5" id="_x0000_i1074" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
<td width="15" valign="top" style="width:3.75pt;padding:0in 0in 0in 0in;height:.75pt">
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1075" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;font-family:"Arial",sans-serif;color:#333333">Communication: Principles</span></b><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><i><span style="color:#333333">Make it a habit to "pass it on"</span></i><span style="color:#333333"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Effective communication means passing the information on to others.
<b>Don't assume they already know. </b>When we pass information on, we empower each other.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">For example, you receive Tech-Talk. What do you do with it?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">Every library license allows</span></b><span style="color:#333333">, and encourages, you to:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo17">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">SHARE with every librarian, library staff, library volunteer.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo17">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">USE THE CONTENT in developing classes for patrons and staff.<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-left:30.0pt;text-indent:-12.0pt;mso-list:l0 level1 lfo17">
<![if !supportLists]><span style="font-size:10.0pt;font-family:Symbol;color:#333333"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman"">
</span></span></span><![endif]><span style="color:#333333">HELP PATRONS to solve problems, answer questions with the information you've learned and can find for them in the Tech-Talk Database.<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">So if others in your library are not getting Tech-Talk, pass it on!<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">TIP:</span></b><span style="color:#333333"> If you want to give Tech-Talk to patrons, students and faculty, libraries can get an unlimited license to do that by
<a href="mailto:support@tech-talk.com" target="_blank"><span style="color:#3661BD">contacting us</span></a>.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="color:#333333">What about other important emails and documents</span></b><span style="color:#333333"> that you get at work? When you look at the distribution, are there others who would benefit if you passed it on?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="color:#333333">Think inclusive! Be a communication facilitator.
<b>Think, "passing it on"</b> as a matter of routine.<o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr style="height:.75pt">
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 8.25pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1076" src="https://imgssl.constantcontact.com/letters/images/1101116784221/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="50%" valign="top" style="width:50.0%;background:#3661BD;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><a href="http://r20.rs6.net/tn.jsp?f=001Xll4kKeM-_kWTdSTIJMxDQTEB7_yE52nX6gtFjZbmri7TLxSiCJlkwv-m5ELlZmXlgXE_Xq2WbJ_fiWkj_RvEkyfCSVfNMTaWYRIKJPlT2pf8NKgajw1MTtObIUQBHrTy2X2uLwLgSL9rS9rSPqg0V2blJ9pS_fI&c=1Hvl0kulQha5EmOpSTAxNlXBUdgVByUWHYfWq6TpnyeouhsV39xVTA==&ch=eFFXaLtIgrfHtbepbxKoVkx1nqF6Jc1z958tgrwfFcGEjy7QZkc7sw=="><span style="text-decoration:none"><img border="0" width="272" id="_x0000_i1077" src="http://files.constantcontact.com/ee1208b4001/b13a7a6a-7445-4d8e-b741-4b475385ef5b.png"></span></a><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
<td width="50%" valign="top" style="width:50.0%;background:#3661BD;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in">
<div>
<p class="MsoNormal" align="center" style="text-align:center"><a href="http://r20.rs6.net/tn.jsp?f=001Xll4kKeM-_kWTdSTIJMxDQTEB7_yE52nX6gtFjZbmri7TLxSiCJlkwGQKcgXPyVcqiRUEP89U84lfyr_jbOaU_mSfbyWzxlfFn8MxxDYdJyFp61_C6_6WKQZWHLGcRHocm_3uP-SufBGK8aItj_fQqDrg7QjSh8HLWyzomdEuWU=&c=1Hvl0kulQha5EmOpSTAxNlXBUdgVByUWHYfWq6TpnyeouhsV39xVTA==&ch=eFFXaLtIgrfHtbepbxKoVkx1nqF6Jc1z958tgrwfFcGEjy7QZkc7sw=="><span style="text-decoration:none"><img border="0" width="271" id="_x0000_i1078" src="http://files.constantcontact.com/ee1208b4001/8751eb23-fa9b-43ba-9f5f-7e80a465c6c5.png" alt="Ask a question"></span></a><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td valign="top" style="padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%;cursor:default">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:3.75pt 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr style="height:.75pt">
<td style="background:#478CCB;padding:0in 0in 5.25pt 0in;height:.75pt">
<div>
<p class="MsoNormal" align="center" style="text-align:center;mso-line-height-alt:.75pt">
<img border="0" width="5" height="1" id="_x0000_i1079" src="https://imgssl.constantcontact.com/letters/images/sys/S.gif"><o:p></o:p></p>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<p class="MsoNormal" align="center" style="text-align:center"><o:p> </o:p></p>
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;min-width: 100%">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in;word-wrap: break-word">
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse;word-wrap: break-word">
<tbody>
<tr>
<td valign="top" style="padding:7.5pt 15.0pt 7.5pt 15.0pt">
<div>
<div>
<div>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#1F4E79">Copyright 1996-2019 Shared Results International. Published weekly. Do not forward this issue of Tech-Talk.com without prior
permission from Shared Results International. Distribution is limited by contract. Forwarding it to unauthorized recipients constitutes copyright infringement.
<br>
For information on site licenses or how to include additional recipients, email <a href="mailto:darci.hanning@state.or.us">
darci.hanning@state.or.us</a></span><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#333333">.</span><span style="color:#333333"><o:p></o:p></span></p>
</div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;background:white;border-collapse:collapse">
<tbody>
<tr>
<td width="100%" valign="top" style="width:100.0%;padding:0in 0in 0in 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:12.0pt 0in 12.0pt 0in">
<div align="center">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="0" style="width:435.0pt;border-collapse:collapse">
<tbody>
<tr>
<td valign="top" style="padding:3.0pt 0in 3.0pt 0in">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D">The Tech-Talk e-newsletter for Oregon library staff is distributed weekly via the Libs-OR and TechTalk mailing lists.
<b>Please do not forward. </b>Know someone who might be interested in receiving a copy but they’re not on Libs-OR? Have them contact
<a href="mailto:darci.hanning@state.or.us">darci.hanning@state.or.us</a> or visit
<a href="http://listsmart.osl.state.or.us/mailman/listinfo/techtalk">http://listsmart.osl.state.or.us/mailman/listinfo/techtalk</a> to subscribe to just the Tech-Talk newsletter!<o:p></o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal" align="center" style="text-align:center"><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1F497D">Tech-Talk is a paid subscription service for staff of Oregon libraries and is supported in whole by the Institute of
Museum and Library Services (IMLS) through the Library Services and Technology Act (LSTA), administered by the State Library of Oregon.</span></b><span style="font-size:9.0pt;font-family:"Verdana",sans-serif;color:#5D5D5D">
<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:7.5pt 0in 7.5pt 0in"></td>
</tr>
<tr>
<td valign="top" style="padding:3.0pt 0in 3.0pt 0in"></td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D">Cheers,<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:3.0pt"><b><span style="font-size:10.0pt;font-family:"Century Gothic",sans-serif;color:black">Darci Hanning, MLIS<o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:3.0pt;line-height:115%"><b><span style="font-size:11.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#1F4E79">Public Library Consultant / CE Coordinator<br>
</span></b><span style="font-size:11.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#1F4E79"><a href="mailto:darci.hanning@state.or.us"><b><span style="color:#2E74B5">darci.hanning@state.or.us</span></b></a><b> | 503-378-2527|
</b><a href="https://www.oregon.gov/library"><b><span style="color:#0563C1">www.oregon.gov/library</span></b></a></span><b><u><span style="font-size:11.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#0563C1"><o:p></o:p></span></u></b></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F4E79">Follow us:
</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F4E79"><a href="http://fb.me/StateLibraryOR"><b><span style="color:#0563C1">Facebook</span></b></a><b> |
</b><a href="https://twitter.com/StateLibraryOR"><b><span style="color:#0563C1">Twitter</span></b></a><b> |
</b><a href="http://www.statelibraryor.tumblr.com/"><b><span style="color:#0563C1">Tumblr</span></b></a><b> |
</b><a href="https://pinterest.com/statelibraryor/"><b><span style="color:#0563C1">Pinterest</span></b></a><b><o:p></o:p></b></span></p>
<p class="MsoNormal" style="margin-bottom:3.0pt;line-height:115%"><span style="font-size:11.0pt;line-height:115%;font-family:"Calibri",sans-serif;color:#1F4E79"><br>
<img border="0" width="342" height="43" id="Picture_x0020_1" src="cid:image001.png@01D55D8A.176172B0" alt="cid:image005.png@01D31C27.4B9FEA30"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Arial",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
</div>
</body>
</html>