Use Msdn to search the Web.http://feedproxy.google.com/~r/microsoft/zLwJ/~3/Dk-KW6U0Uuk/231114The SUMIF and COUNTIF functions return incorrect results when you use them to match strings longer than 255 characters to the string #VALUE!.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/Dk-KW6U0Uuk" height="1" width="1"/>http://support.microsoft.com/kb/231114http://feedproxy.google.com/~r/microsoft/zLwJ/~3/ieZOgmXKrVw/150369In 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.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/ieZOgmXKrVw" height="1" width="1"/>http://support.microsoft.com/kb/150369http://feedproxy.google.com/~r/microsoft/zLwJ/~3/ODCxn58XvyI/260415A 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/ODCxn58XvyI" height="1" width="1"/>http://support.microsoft.com/kb/260415http://feedproxy.google.com/~r/microsoft/zLwJ/~3/NLmGCRSq-nQ/214286In 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/NLmGCRSq-nQ" height="1" width="1"/>http://support.microsoft.com/kb/214286http://feedproxy.google.com/~r/microsoft/zLwJ/~3/U4vNz7CZsqg/192222In 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/U4vNz7CZsqg" height="1" width="1"/>http://support.microsoft.com/kb/192222http://feedproxy.google.com/~r/microsoft/zLwJ/~3/0ASnEjeV3_8/179029COUNTIF: 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/0ASnEjeV3_8" height="1" width="1"/>http://support.microsoft.com/kb/179029http://feedproxy.google.com/~r/microsoft/zLwJ/~3/DlomyVyGl2Q/216578COUNTIF 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<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/DlomyVyGl2Q" height="1" width="1"/>http://support.microsoft.com/kb/216578http://feedproxy.google.com/~r/microsoft/zLwJ/~3/fu1JlJWSbPs/214153This 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/fu1JlJWSbPs" height="1" width="1"/>http://support.microsoft.com/kb/214153http://feedproxy.google.com/~r/microsoft/zLwJ/~3/BCwqnykib3E/237188COUNTIF 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/BCwqnykib3E" height="1" width="1"/>http://support.microsoft.com/kb/237188http://feedproxy.google.com/~r/microsoft/zLwJ/~3/x7Lt_JZXN5U/232507If 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/x7Lt_JZXN5U" height="1" width="1"/>http://support.microsoft.com/kb/232507http://feedproxy.google.com/~r/microsoft/zLwJ/~3/kz62GMfRZRk/231000... 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/kz62GMfRZRk" height="1" width="1"/>http://support.microsoft.com/kb/231000http://feedproxy.google.com/~r/microsoft/zLwJ/~3/O0oPrN5D0U4/232494... 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/O0oPrN5D0U4" height="1" width="1"/>http://support.microsoft.com/kb/232494http://feedproxy.google.com/~r/microsoft/zLwJ/~3/wRhuw6dKN8A/en-gbThe COUNTIF function is similar to SUMIF, except it counts the number of cells that meet ... Not all Excel’s functions exist in the program itself. Many useful ones are included in ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/wRhuw6dKN8A" height="1" width="1"/>http://support.microsoft.com/kb/841341/en-gbhttp://feedproxy.google.com/~r/microsoft/zLwJ/~3/Kk4EwpzoUMI/bb211378.aspxCountIf. CountIfs. CoupDayBs. CoupDays. CoupDaysNc. CoupNcd. CoupNum. CoupPcd. Covar. Creator ... Events, Worksheet Functions, and Shapes List of Worksheet Functions Available to Visual Basic<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/Kk4EwpzoUMI" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb211378.aspxhttp://feedproxy.google.com/~r/microsoft/zLwJ/~3/2Uu3SSvQW0Q/en-hkRequires that you use the SUM, COUNTIF, and LEN functions. Description of improvements in the statistical functions in Excel 2003 and in Excel 2004 for Mac<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/2Uu3SSvQW0Q" height="1" width="1"/>http://support.microsoft.com/ph/2513/en-hk?sid=202&aid=1&GSA_AC_More1http://feedproxy.google.com/~r/microsoft/zLwJ/~3/VaYF0hLTG24/en-hkRequires 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/VaYF0hLTG24" height="1" width="1"/>http://support.microsoft.com/ph/2513/en-hk?sid=1051&aid=1&GSA_AC_More1http://feedproxy.google.com/~r/microsoft/zLwJ/~3/FrdnHzjkTBk/en-hkHow-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<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/FrdnHzjkTBk" height="1" width="1"/>http://support.microsoft.com/ph/2513/en-hk?sid=202http://feedproxy.google.com/~r/microsoft/zLwJ/~3/fwfXHYE_H6s/2513Requires that you use the SUM, COUNTIF, and LEN functions. Description of improvements in the statistical functions in Excel 2003 and in Excel 2004 for Mac<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/fwfXHYE_H6s" height="1" width="1"/>http://support.microsoft.com/ph/2513?sid=202http://feedproxy.google.com/~r/microsoft/zLwJ/~3/T-n_KBhKsSQ/en-hkRequires that you use the SUM, COUNTIF, and LEN functions. How Microsoft Excel works with two-digit year numbers When you type a date using a two-digit year number (such as 98 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/T-n_KBhKsSQ" height="1" width="1"/>http://support.microsoft.com/ph/2513/en-hk?sid=1293&aid=1&GSA_AC_More1http://feedproxy.google.com/~r/microsoft/zLwJ/~3/EEs9U74YVVA/en-idRequires that you use the SUM, COUNTIF, and LEN functions. Description of improvements in the statistical functions in Excel 2003 and in Excel 2004 for Mac<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/EEs9U74YVVA" height="1" width="1"/>http://support.microsoft.com/ph/2513/en-id?sid=202http://feedproxy.google.com/~r/microsoft/zLwJ/~3/TdOYkg_KgXo/2513Requires 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/TdOYkg_KgXo" height="1" width="1"/>http://support.microsoft.com/ph/2513?sid=745&aid=1&GSA_AC_More1http://feedproxy.google.com/~r/microsoft/zLwJ/~3/AGxjYm1-RoA/aa730921.aspxIF (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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/AGxjYm1-RoA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa730921.aspxhttp://feedproxy.google.com/~r/microsoft/zLwJ/~3/6EdyEDEXaGk/en-hkRequires 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/6EdyEDEXaGk" height="1" width="1"/>http://support.microsoft.com/ph/2513/en-hk?sid=340&aid=1&GSA_AC_More1http://feedproxy.google.com/~r/microsoft/zLwJ/~3/6I3AtLPzz8Y/825012If 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/6I3AtLPzz8Y" height="1" width="1"/>http://support.microsoft.com/kb/825012http://feedproxy.google.com/~r/microsoft/zLwJ/~3/zAC5oKO-mbA/en-hkRequires 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 ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/zAC5oKO-mbA" height="1" width="1"/>http://support.microsoft.com/ph/2513/en-hk?sid=659&aid=1&GSA_AC_More1http://feedproxy.google.com/~r/microsoft/zLwJ/~3/qrKUPKzytEM/en-hkRequires that you use the SUM, COUNTIF, and LEN functions. Resources that offer information about programming in Visual Basic in Excel for Mac<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/qrKUPKzytEM" height="1" width="1"/>http://support.microsoft.com/ph/2513/en-hk?sid=470&aid=1&GSA_AC_More1http://feedproxy.google.com/~r/microsoft/zLwJ/~3/8UG08FNi49I/214274There are many functions that have changed since Microsoft Excel version 4.0, and there ... HLOOKUP() x VLOOKUP() x COUNTIF ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/8UG08FNi49I" height="1" width="1"/>http://support.microsoft.com/kb/214274http://feedproxy.google.com/~r/microsoft/zLwJ/~3/Ox9elemnElU/211444Functions in your formulas refer to arguments that do not exist in the earlier version of ... x CONCATENATE x COUNTBLANK x COUNTIF ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/Ox9elemnElU" height="1" width="1"/>http://support.microsoft.com/kb/211444http://feedproxy.google.com/~r/microsoft/zLwJ/~3/kiil6VRouuA/886615Incorrect Help topic for Functions returned in the German language version of Excel 2003 ... COUNTIF: FISHERINV: FTEST: FVERT: GAMMAINV: GAMMALN: GAMMAVERT: GEOMITTEL: GESTUTZTMITTEL<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/kiil6VRouuA" height="1" width="1"/>http://support.microsoft.com/kb/886615http://feedproxy.google.com/~r/microsoft/zLwJ/~3/dNC0Mt2DIpc/bb225774.aspxUsed 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.<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/dNC0Mt2DIpc" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb225774.aspxhttp://feedproxy.google.com/~r/microsoft/zLwJ/~3/kufc6nXJ5NM/181284Functions in your formulas refer to arguments that do not exist in the earlier version ... x CONCATENATE x COUNTBLANK x COUNTIF ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/kufc6nXJ5NM" height="1" width="1"/>http://support.microsoft.com/kb/181284http://feedproxy.google.com/~r/microsoft/zLwJ/~3/t47OUyrj2eo/167077Functions in your formulas refer to arguments that do not exist in the earlier version ... x CONCATENATE x COUNTBLANK x COUNTIF ...<img src="http://feeds.feedburner.com/~r/microsoft/zLwJ/~4/t47OUyrj2eo" height="1" width="1"/>http://support.microsoft.com/kb/167077