Use Msdn to search the Web.http://feedproxy.google.com/~r/microsoft/fewS/~3/Te6YHzQ-7gE/275165You can use the SUMIF() worksheet function in Microsoft Excel for either of the following situations: When you want to return a sum for a single criteria (for example, a single IF ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/Te6YHzQ-7gE" height="1" width="1"/>http://support.microsoft.com/kb/275165http://feedproxy.google.com/~r/microsoft/fewS/~3/vsJ1TnVnCvI/213181When you try to create an array formula by using a Visual Basic for Applications macro, you may receive the following error message:<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/vsJ1TnVnCvI" height="1" width="1"/>http://support.microsoft.com/kb/213181http://feedproxy.google.com/~r/microsoft/fewS/~3/2eddghQ4eCQ/bb208529.aspxReturns or sets the array formula of a range. Returns (or can be set to) a single formula or a Visual Basic array. If the specified range doesn't contain an array formula, this ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/2eddghQ4eCQ" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb208529.aspxhttp://feedproxy.google.com/~r/microsoft/fewS/~3/QKD2xl1zfOs/158080When you run a Visual Basic for Applications macro in Microsoft Excel 97, you may receive the following error message: Or when you manually paste a copied cell in Microsoft Excel ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/QKD2xl1zfOs" height="1" width="1"/>http://support.microsoft.com/kb/158080http://feedproxy.google.com/~r/microsoft/fewS/~3/DR0C9C5C0fY/152567NOTE: The formula must be entered as an array formula. To enter a formula as an array formula in Microsoft Excel for Windows, press CTRL+SHIFT+ENTER.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/DR0C9C5C0fY" height="1" width="1"/>http://support.microsoft.com/kb/152567http://feedproxy.google.com/~r/microsoft/fewS/~3/OUZV7g8e0eQ/906311Describes an issue in which you cannot share an Excel workbook that contains an array formula that is linked to another workbook.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/OUZV7g8e0eQ" height="1" width="1"/>http://support.microsoft.com/kb/906311http://feedproxy.google.com/~r/microsoft/fewS/~3/Q_dp8t6qcRc/213568When you copy and paste a formula, you may receive the following error message: You cannot change part of an array. -or- When you run a Visual Basic for Applications macro, you may ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/Q_dp8t6qcRc" height="1" width="1"/>http://support.microsoft.com/kb/213568http://feedproxy.google.com/~r/microsoft/fewS/~3/-830DDmSUe8/100122If the bins array contains four values, select five cells. For example, select cells C1:C5. On the Formula menu, click Paste Function. Click the Paste Arguments check box to ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/-830DDmSUe8" height="1" width="1"/>http://support.microsoft.com/kb/100122http://feedproxy.google.com/~r/microsoft/fewS/~3/kSGNRzfICnM/166342Because recalculating an array formula that uses a whole column of cells is time consuming, Excel does not allow you to create this kind of array in a formula.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/kSGNRzfICnM" height="1" width="1"/>http://support.microsoft.com/kb/166342http://feedproxy.google.com/~r/microsoft/fewS/~3/ODCxn58XvyI/260415To enter a formula as an array formula in Microsoft Excel for Windows, press CTRL+SHIFT+ENTER. SUMIF Instead of using a formula that is similar to the following<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/ODCxn58XvyI" height="1" width="1"/>http://support.microsoft.com/kb/260415http://feedproxy.google.com/~r/microsoft/fewS/~3/MVWZGxZAQRs/100790In Microsoft Excel, you can use the FREQUENCY() function in a SUM(IF()) array formula to count the number of rows in which an item appears within a specified range. To count how ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/MVWZGxZAQRs" height="1" width="1"/>http://support.microsoft.com/kb/100790http://feedproxy.google.com/~r/microsoft/fewS/~3/CSef7R3bIvU/192989When you try to create an array formula by using a Visual Basic for Applications macro, you may receive the following error message:<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/CSef7R3bIvU" height="1" width="1"/>http://support.microsoft.com/kb/192989http://feedproxy.google.com/~r/microsoft/fewS/~3/RHYxpWJo2eo/192990When you try to create an array formula by using a Visual Basic for Applications macro, you may receive the following error message:<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/RHYxpWJo2eo" height="1" width="1"/>http://support.microsoft.com/kb/192990http://feedproxy.google.com/~r/microsoft/fewS/~3/eILLx-a8_zg/272864When you use an array formula based on a very large range (For example, over 25 columns and 1,000 rows), Microsoft Excel for Mac does not return a result. The cells do not appear ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/eILLx-a8_zg" height="1" width="1"/>http://support.microsoft.com/kb/272864http://feedproxy.google.com/~r/microsoft/fewS/~3/1t0dxSybGkk/59482The formula returns the value 8.00. You must enter this formula as an array formula by pressing CTRL+SHIFT+ENTER (in Microsoft Excel for Windows and OS/2) or COMMAND+RETURN (in ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/1t0dxSybGkk" height="1" width="1"/>http://support.microsoft.com/kb/59482http://feedproxy.google.com/~r/microsoft/fewS/~3/FIAAzmc7gQY/214053Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 27.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/FIAAzmc7gQY" height="1" width="1"/>http://support.microsoft.com/kb/214053http://feedproxy.google.com/~r/microsoft/fewS/~3/l-aegRNbLbs/214054In Microsoft Excel, you may receive the following error message when you attempt to edit one of the cells that make up an array formula.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/l-aegRNbLbs" height="1" width="1"/>http://support.microsoft.com/kb/214054http://feedproxy.google.com/~r/microsoft/fewS/~3/vgLiHiKBSWg/108107NOTE: The above formulas must be entered as array formulas. To enter a formula as an array formula in Microsoft Excel for Windows or Microsoft Excel for OS/2, press CTRL+SHIFT ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/vgLiHiKBSWg" height="1" width="1"/>http://support.microsoft.com/kb/108107http://feedproxy.google.com/~r/microsoft/fewS/~3/LlVAUpcONXQ/970262Autofit does not work when using a formula array greater than 32768 and less than 65536 cells. Cells are truncated and displayed by pound signs.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/LlVAUpcONXQ" height="1" width="1"/>http://support.microsoft.com/kb/970262http://feedproxy.google.com/~r/microsoft/fewS/~3/vD1iCDfV6zo/171026In Microsoft Excel 97, if you copy a range of cells from one workbook and paste the copied cells into another workbook, you may receive the following error message: If you click ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/vD1iCDfV6zo" height="1" width="1"/>http://support.microsoft.com/kb/171026http://feedproxy.google.com/~r/microsoft/fewS/~3/CfHtL79JRa0/107905In Microsoft Excel, you may receive the error message "Cannot change part of an array" when you attempt to edit one of the cells that make up an array formula.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/CfHtL79JRa0" height="1" width="1"/>http://support.microsoft.com/kb/107905http://feedproxy.google.com/~r/microsoft/fewS/~3/BZnP66QbgUM/129423NOTE: You must enter the above formula as an array formula. To enter a formula as an array formula in Microsoft Excel for Windows, press CTRL+SHIFT+ENTER.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/BZnP66QbgUM" height="1" width="1"/>http://support.microsoft.com/kb/129423http://feedproxy.google.com/~r/microsoft/fewS/~3/caFcwhGJckI/bb215277.aspxBecause FREQUENCY returns an array, it must be entered as an array formula. Syntax. expression.Frequency(Arg1, Arg2) expression A variable that represents a WorksheetFunction object<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/caFcwhGJckI" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb215277.aspxhttp://feedproxy.google.com/~r/microsoft/fewS/~3/9YZh5id_-U4/bb239407.aspxBecause this function returns an array of values, it must be entered as an array formula. Syntax. expression.LinEst(Arg1, Arg2, Arg3, Arg4) expression A variable that represents a ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/9YZh5id_-U4" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb239407.aspxhttp://feedproxy.google.com/~r/microsoft/fewS/~3/xQkEJJ84gd0/248181If you copy a range of cells containing an array formula and paste it to another range, Excel may crash, and you may receive the following error message: This program has performed ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/xQkEJJ84gd0" height="1" width="1"/>http://support.microsoft.com/kb/248181http://feedproxy.google.com/~r/microsoft/fewS/~3/6Nqn31SJSNQ/bb239411.aspxBecause this function returns an array of values, it must be entered as an array formula. Syntax. expression.LogEst(Arg1, Arg2, Arg3, Arg4) expression A variable that represents a ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/6Nqn31SJSNQ" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb239411.aspxhttp://feedproxy.google.com/~r/microsoft/fewS/~3/aYmv7YNpMh8/214142Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00. Select cell F2, grab the fill handle, and then fill down to cell F5 to ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/aYmv7YNpMh8" height="1" width="1"/>http://support.microsoft.com/kb/214142http://feedproxy.google.com/~r/microsoft/fewS/~3/olNh8bBlvTA/173954When you enter a formula in a worksheet, some of the values that are returned by the formula may be incorrect.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/olNh8bBlvTA" height="1" width="1"/>http://support.microsoft.com/kb/173954http://feedproxy.google.com/~r/microsoft/fewS/~3/a7w13_0H9iI/324986Formula: Description (Result) =LOOKUP("c",A1:B4) Looks up "C" in first row of the array and returns the value in the last row that is in the same column (3).<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/a7w13_0H9iI" height="1" width="1"/>http://support.microsoft.com/kb/324986http://feedproxy.google.com/~r/microsoft/fewS/~3/rCHEGHaHXzo/181285Because recalculating an array formula that uses an entire column of cells is somewhat time consuming (65,536 cells per column), Microsoft Excel does not allow you to create this ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/rCHEGHaHXzo" height="1" width="1"/>http://support.microsoft.com/kb/181285http://feedproxy.google.com/~r/microsoft/fewS/~3/fM2j5uvFf3c/bb239806.aspxReturns a vertical range of cells as a horizontal range, or vice versa. TRANSPOSE must be entered as an array formula in a range that has the same number of rows and columns ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/fM2j5uvFf3c" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb239806.aspxhttp://feedproxy.google.com/~r/microsoft/fewS/~3/0ASnEjeV3_8/179029To enter a formula as an array formula in Microsoft Excel for the Macintosh, press COMMAND+RETURN. SUMIF: Instead of using a formula that is similar to the following<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/0ASnEjeV3_8" height="1" width="1"/>http://support.microsoft.com/kb/179029http://feedproxy.google.com/~r/microsoft/fewS/~3/9H7Nr8d96lA/906310Describes a behavior in which calculation takes longer than expected when a formula depends on a custom array function in an Excel 2003 worksheet or in an Excel 2002 worksheet.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/9H7Nr8d96lA" height="1" width="1"/>http://support.microsoft.com/kb/906310http://feedproxy.google.com/~r/microsoft/fewS/~3/eW11yjf8eek/187667Note The above formula must be entered as an array formula. To enter a formula as an array formula, press COMMAND+RETURN. The formula must be divided by the length of the text ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/eW11yjf8eek" height="1" width="1"/>http://support.microsoft.com/kb/187667http://feedproxy.google.com/~r/microsoft/fewS/~3/2aXDhOBQ-y8/192872NOTE: The above formulas must be entered as array formulas. To enter a formula as an array formula, press COMMAND+RETURN.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/2aXDhOBQ-y8" height="1" width="1"/>http://support.microsoft.com/kb/192872http://feedproxy.google.com/~r/microsoft/fewS/~3/OOSFI9-4WUs/71952The formula returns 11215.34 ($11,215.34). The ROW function is used in this formula to return an array of period numbers, and any range can be used here.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/OOSFI9-4WUs" height="1" width="1"/>http://support.microsoft.com/kb/71952http://feedproxy.google.com/~r/microsoft/fewS/~3/NLmGCRSq-nQ/214286Method 2 To use the SUM(IF()) function to enter the array, use a formula similar to the following:<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/NLmGCRSq-nQ" height="1" width="1"/>http://support.microsoft.com/kb/214286http://feedproxy.google.com/~r/microsoft/fewS/~3/fu1JlJWSbPs/214153To enter an array formula, press CTRL+SHIFT+ENTER. Method 2 Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/fu1JlJWSbPs" height="1" width="1"/>http://support.microsoft.com/kb/214153http://feedproxy.google.com/~r/microsoft/fewS/~3/q1QtNmH-Iek/213889Note The above formula must be entered as an array formula. To enter a formula as an array in Excel for Windows, press CTRL+SHIFT+ENTER. To enter a formula as an array in Excel ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/q1QtNmH-Iek" height="1" width="1"/>http://support.microsoft.com/kb/213889http://feedproxy.google.com/~r/microsoft/fewS/~3/TmPKxGimSIA/843504Note Make sure that you enter the formula as an array by pressing CTRL+SHIFT+ENTER. After you do this, you see curly braces {} surrounding the formula.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/TmPKxGimSIA" height="1" width="1"/>http://support.microsoft.com//kb/843504http://feedproxy.google.com/~r/microsoft/fewS/~3/Yi4Sw6-Q5nU/bb208593.aspxTrue if the specified cell is part of an array formula. Read-only Variant.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/Yi4Sw6-Q5nU" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb208593.aspxhttp://feedproxy.google.com/~r/microsoft/fewS/~3/0HUDpazArw0/109211NOTE: The above formula must be entered as an array formula. To enter a formula as an array formula in Microsoft Excel for Windows or Microsoft Excel for OS/2, press CTRL+SHIFT ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/0HUDpazArw0" height="1" width="1"/>http://support.microsoft.com/kb/109211http://feedproxy.google.com/~r/microsoft/fewS/~3/DnbfcO5kd4E/282158Describes the fact that when you enter an array formula, the background error checker does not flag the formula as an error.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/DnbfcO5kd4E" height="1" width="1"/>http://support.microsoft.com/kb/282158http://feedproxy.google.com/~r/microsoft/fewS/~3/N0Ar08Ts-kY/60116This returns an array of a single value with the smallest positive number. NOTE: To enter an array formula in Excel for the Macintosh, press COMMAND+RETURN.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/N0Ar08Ts-kY" height="1" width="1"/>http://support.microsoft.com/kb/60116http://feedproxy.google.com/~r/microsoft/fewS/~3/U4vNz7CZsqg/192222Method 2 To use the SUM(IF()) function to enter the array, use a formula similar to the following:<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/U4vNz7CZsqg" height="1" width="1"/>http://support.microsoft.com/kb/192222http://feedproxy.google.com/~r/microsoft/fewS/~3/SnDPqE1PqzA/323225NOTE: You must input this formula as an array formula. To input a formula as an array formula, press COMMAND+RETURN. The formula returns the full path and worksheet name of the ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/SnDPqE1PqzA" height="1" width="1"/>http://support.microsoft.com/kb/323225http://feedproxy.google.com/~r/microsoft/fewS/~3/0kmCxSbT7vY/133204In the versions of Microsoft Excel listed above, if you use the ActiveCell property in conjunction with the FormulaArray property, the resulting formula may not be entered as an ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/0kmCxSbT7vY" height="1" width="1"/>http://support.microsoft.com/kb/133204http://feedproxy.google.com/~r/microsoft/fewS/~3/n4rzaGSSrRo/bb687844.aspxMixed-type arrays of these types can also be entered into formulas as arguments to functions or as values spanning more than one cell in an array formula.<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/n4rzaGSSrRo" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/bb687844.aspxhttp://feedproxy.google.com/~r/microsoft/fewS/~3/btUCS-zibYo/214084NOTE: You must input this formula as an array formula. To input a formula as an array formula, press CTRL+SHIFT+ENTER. The formula returns the full path and worksheet name of ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/btUCS-zibYo" height="1" width="1"/>http://support.microsoft.com/kb/214084http://feedproxy.google.com/~r/microsoft/fewS/~3/AGxjYm1-RoA/aa730921.aspxRemember that an array formula is a bit like a volatile formula: If any one of the cells that it references has changed, is volatile, or has been recalculated, the array formula ...<img src="http://feeds.feedburner.com/~r/microsoft/fewS/~4/AGxjYm1-RoA" height="1" width="1"/>http://msdn.microsoft.com/en-us/library/aa730921.aspx