document.write('<div class="feedburnerFeedBlock" id="microsoft/zLwJ9p80s4m6r1gl5fj1u0jsp3bm9s">');
document.write('<p class="feedTitle">CountIf Function</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/231114" target="_blank" >XL2000: SUMIF and COUNTIF Functions Return Incorrect Results When Used ...</a></span>');
document.write('<div>The SUMIF and COUNTIF functions return incorrect results when you use them to match strings longer than 255 characters to the string #VALUE!.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/260415" target="_blank" >SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error</a></span>');
document.write('<div>A formula that contains the SUMIF, COUNTIF, or COUNTBLANK functions may return the #VALUE! error in Microsoft Excel. Note This behavior also applies to the Dfunctions, such as ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/150369" target="_blank" >COUNTIF\/SUMIF Wrong If Cell Has Single Apostrophes</a></span>');
document.write('<div>In Microsoft Excel, when you use the COUNTIF and SUMIF functions, you may receive incorrect results if cells included in the range argument contain an apostrophe.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/216578" target="_blank" >XL2000: Calculation Differences Between the Office Spreadsheet and ...</a></span>');
document.write('<div>COUNTIF and SUMIF Criteria You can use the functions COUNTIF and SUMIF to count or add cells specified by a given criteria. Greater Than or Less Than Criteria</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/232507" target="_blank" >XL98: COUNTIF Returns Incorrect Value When It Refers to Blank Cells</a></span>');
document.write('<div>If the COUNTIF function returns an incorrect smaller value due to this problem, and the workaround is applied, you must cause Excel to completely recalculate before the functions ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/192222" target="_blank" >XL98: Some Worksheet Functions Do Not Allow Array Constants</a></span>');
document.write('<div>In Microsoft Excel 98 Macintosh Edition, you may receive one of the following error messages if you insert an array constant (such as {1,2}) into a SUMIF(), COUNTIF(), or ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214286" target="_blank" >XL: Some Worksheet Functions Do Not Allow Array Constants</a></span>');
document.write('<div>In Microsoft Excel, you may receive one of the following error messages if you insert an array constant (such as {1,2}) into a SUMIF(), COUNTIF(), or COUNTBLANK() function: -or ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214153" target="_blank" >How to count the occurrences of a number or text in a range in Excel ...</a></span>');
document.write('<div>This article explains how you can use worksheet functions in Microsoft Excel for Mac to ... Wildcard characters can be used within the COUNTIF function. The asterisk character ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/179029" target="_blank" >XL98: SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error</a></span>');
document.write('<div>COUNTIF: Instead of using a formula that is similar to the following ... To start the wizard that helps you create these functions in Microsoft Excel 98 Macintosh ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/237188" target="_blank" >XL97: SUMIF, COUNTIF, COUNTBLANK Return #VALUE! Error</a></span>');
document.write('<div>COUNTIF Instead of using a formula that is similar to the following ... For more information about a wizard that can help you create these functions, click the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=202&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. Misleading labels in the output of the Analysis ToolPak t-Test tools in Excel Discusses the problem that the Analysis ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=202" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>How-to articles - Functions. How to use the INDEX and MATCH worksheet functions ... whether the list contains blank entries. Requires that you use the SUM, COUNTIF, and LEN functions</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/232494" target="_blank" >XL97: COUNTIF Returns Incorrect Value When It Refers to Blank Cells</a></span>');
document.write('<div>... the COUNTIF function returns an incorrect smaller value because of this problem, and the workaround is applied, you must cause Excel to completely recalculate before the functions ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/231000" target="_blank" >XL2000: COUNTIF Returns Incorrect Value When It Refers to Blank Cells</a></span>');
document.write('<div>... the COUNTIF function returns an incorrect smaller value because of this problem and the workaround is applied, you must cause Excel to completely recalculate before the functions ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb211378.aspx" target="_blank" >List of Worksheet Functions Available to Visual Basic\u00A0[Excel 2007 ...</a></span>');
document.write('<div>CountIf. CountIfs. CoupDayBs. CoupDays. CoupDaysNc. CoupNcd. CoupNum. CoupPcd. Covar. Creator ... Events, Worksheet Functions, and Shapes List of Worksheet Functions Available to Visual Basic</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/841341/en-gb" target="_blank" >The secrets of Excel: formulas and functions</a></span>');
document.write('<div>The COUNTIF function is similar to SUMIF, except it counts the number of cells that meet ... Not all Excel\u2019s functions exist in the program itself. Many useful ones are included in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1292&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. Misleading labels in the output of the Analysis ToolPak t-Test tools in Excel Discusses the problem that the Analysis ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa730921.aspx" target="_blank" >Improving Performance in Excel 2007</a></span>');
document.write('<div>IF (COUNTIF(lookuparray,lookupvalue)=0, 0, _ VLOOKUP(lookupval, table, 2 FALSE)) ... XLM functions can also be fast, because they use the same tightly coupled API as C XLL add ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1292" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. Misleading labels in the output of the Analysis ToolPak t-Test tools in Excel Discusses the problem that the Analysis ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1293&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. Misleading labels in the output of the Analysis ToolPak t-Test tools in Excel Discusses the problem that the Analysis ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1051&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. Excel statistical functions: CRITBINOM Describes the CRITBINOM function in Excel 2003 and in later versions of Excel ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=745&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel Describes how to use the INDEX and ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/136733" target="_blank" >Errors Saving File to Earlier Formats</a></span>');
document.write('<div>There are many functions that have changed since Microsoft Excel version 4.0, and there ... HLOOKUP() x VLOOKUP() x COUNTIF ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=340&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. How to combine cells of information in Excel In Microsoft Excel, it is possible to combine, or concatenate, different cells ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=659&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. How to use the INDEX and MATCH worksheet functions with multiple criteria in Excel Describes how to use the INDEX and ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/825012" target="_blank" >How formula calculations are performed in Excel</a></span>');
document.write('<div>If you are using a SUMIF() function or COUNTIF() function where any of the criteria are ... new formula is calculated for the first time, Excel 2007 generates a set of functions ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=470&aid=1&GSA_AC_More1" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Requires that you use the SUM, COUNTIF, and LEN functions. Resources that offer information about programming in Visual Basic in Excel for Mac</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214274" target="_blank" >XL2000: Errors Saving File to Earlier Formats</a></span>');
document.write('<div>There are many functions that have changed since Microsoft Excel version 4.0, and there ... HLOOKUP() x VLOOKUP() x COUNTIF ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/886615" target="_blank" >Incorrect Help topic for Functions returned in the German language ...</a></span>');
document.write('<div>Incorrect Help topic for Functions returned in the German language version of Excel 2003 ... COUNTIF: FISHERINV: FTEST: FVERT: GAMMAINV: GAMMALN: GAMMAVERT: GEOMITTEL: GESTUTZTMITTEL</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb225774.aspx" target="_blank" >WorksheetFunction Object Members</a></span>');
document.write('<div>Used as a container for Microsoft Excel worksheet functions that can be called from Visual ... CountIf: Counts the number of cells within a range that meet the given criteria.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/167077" target="_blank" >XL97: \"Cannot Convert\" Error Saving File in Earlier Format</a></span>');
document.write('<div>Functions in your formulas refer to arguments that do not exist in the earlier version ... x CONCATENATE x COUNTBLANK x COUNTIF ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/211444" target="_blank" >XL2000: \"Cannot Convert\" Error Saving File in Earlier Format</a></span>');
document.write('<div>Functions in your formulas refer to arguments that do not exist in the earlier version of ... x CONCATENATE x COUNTBLANK x COUNTIF ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/181284" target="_blank" >XL98: \"Cannot Convert\" Error Message Saving File in Earlier Format</a></span>');
document.write('<div>Functions in your formulas refer to arguments that do not exist in the earlier version ... x CONCATENATE x COUNTBLANK x COUNTIF ...</div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/zLwJ"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');