Help and Support
 

powered byLive Search

The recalculation of a worksheet that contains a SUMIF formula takes longer to finish than expected in Excel 2007, in Excel 2003, and in Excel 2002

Article ID:902324
Last Review:August 31, 2007
Revision:2.1

SYMPTOMS

When Microsoft Excel recalculates a worksheet that contains a SUMIF formula, the recalculation takes longer to finish than expected.

For example, you type a number into a cell in the worksheet. Then, you press TAB. When Excel recalculates the worksheet, Excel takes longer to move the insertion point to the next cell in the worksheet than expected.

Back to the top

CAUSE

This issue may occur if the arguments in a SUMIF formula do not contain the same number of cells.

For example, this issue may occur if you use the following SUMIF formula in the worksheet.
=SUMIF($C$1:$F$3000,1,$G$1:$G$3000)
Note The first and third arguments in the formula do not contain the same number of cells (rows and columns).

Back to the top

RESOLUTION

To resolve this issue, use the same number of cells in the first and third arguments of the SUMIF formula.

For example, to resolve this issue in the formula in the "Cause" section, change the formula as shown in the following example.
=SUMIF($C$1:$C$3000,1,$G$1:$G$3000)

Back to the top

MORE INFORMATION

For more information about how to use the SUMIF formula, click Microsoft Excel Help on the Help menu, type SUMIF in the Search for box in the Assistance pane, and then click Start searching to view the topic.

Back to the top


APPLIES TO
Microsoft Office Excel 2003
Microsoft Excel 2002 Standard Edition
Microsoft Office Excel 2007

Back to the top

Keywords: 
kbformula kbtshoot kbprb KB902324

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.