Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Pivot Tables » Ignoring blank cells/zeroes in raw data when using Count in a Pivot Table.

Ignoring blank cells/zeroes in raw data when using Count in a Pivot Table.

Previous | Next
Latest post Sun, Mar 20 2011 4:57 AM by Roger Govier. 1 replies.

  • Sat, Mar 19 2011 6:47 PM

    • Lisette
    • Not Ranked
    • Joined on Sat, Mar 19 2011
    • Posts 1
    • Points 21

    Ignoring blank cells/zeroes in raw data when using Count in a Pivot Table.

    Reply |Contact

    Hi,

    I am trying to make a simple Pivot Table.  How do I stop the Pivot Table from counting a zero or blank cell? 

    Each of the zero/blank cells in the raw data contains a fomula, so I assume the Pivot table counts this text?  Anyone know how to stop it?

    Lisette
    • Post Points: 21

  • Sun, Mar 20 2011 4:57 AM In reply to

    • Roger Govier
    • Top 10 Contributor
    • Joined on Tue, Jan 8 2008
    • Abergavenny, South Wales, UK
    • Posts 165
    • Points 2,575
    • MVP

    Re: Ignoring blank cells/zeroes in raw data when using Count in a Pivot Table.

    Reply |Contact |Mark as Answer

    Hi Lisette

    Right click on Field  for your Data values
    Select Field Settings and scroll down Summarize value by and select Count Numbers

    Regards
    Roger Govier
    Microsoft Excel MVP
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.