Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/92563

From BetaArchive Wiki

Excel: Crosstab Wizard Returns Blank Cell for Count



The information in this article applies to:


  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0





SUMMARY

In a crosstab table, the cell where a column count and row count intersect returns a blank cell. This is a limitation of version 4.0 of Microsoft Excel.



MORE INFORMATION

Cells where subtotals intersect are blank by design. If the types of subtotal are not equivalent, such as a SUM and a COUNT, a value for the intersection would result in an inaccurate value. Therefore, the intersection cannot be calculated as a subtotal.




REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, 346-356

Additional query words: blanks database null

Keywords :
Version :
Platform :
Issue type :
Technology :


Last Reviewed: March 29, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.