The information in this article applies to:
SYMPTOMS
When you create a PivotTable with a field that contains blank cells, if you
specify the COUNT function for the "Summarize By" category, Microsoft Excel
will find the blank cells in the column but the count for these blank cells
will be 0.
WORKAROUNDUse the COUNTIF function on the same sheet. COUNTIF will correctly calculate the number of blanks. ExampleTo create this example, use the sample data from the "Example" section in the "Symptoms" section of this article.In cell A17 type: =""In another cell, use the following formula: =COUNTIF(A1:A12,A17)This formula will evaluate to 3. REFERENCESFor more information about the COUNTIF function in Microsoft Excel version 5.0, click the Search button in Help and type: countifFor more information about the COUNTIF function in Microsoft Excel version 7.0, click Answer Wizard on the Help menu, and type: countif Additional query words: 5.00 COUNTIF()
Keywords : |
Last Reviewed: September 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |