+ Reply to Thread
Results 1 to 4 of 4

Pivot table count excluding zero

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Pivot table count excluding zero

    Hello. I have a data set that includes values of "0" in a column. In my pivottable I would like to count non-zero numbers in that column. How can I do this?

  2. #2
    Forum Contributor
    Join Date
    01-29-2009
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    123

    Re: Pivot table count excluding zero

    Put the same field into Report Filter and uncheck "0"

  3. #3
    Registered User
    Join Date
    01-16-2019
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    1

    Re: Pivot table count excluding zero

    If you have multiple fields with zero values, that you do not want to count: may I suggest modifying your data set to use blanks in place of zeros. This avoids Excel counting a zero as a value.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: Pivot table count excluding zero

    Quote Originally Posted by c3me View Post
    If you have multiple fields with zero values, that you do not want to count: may I suggest modifying your data set to use blanks in place of zeros. This avoids Excel counting a zero as a value.
    Thanks for the reply on this (even though it is over 5 years old)

    However, your approach may not always be feasible - there are times when a blank cell is needed (there is no entry to be made, or to be made yet), and times when a zero is needed (there was no xxx counted)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to print all pivot table filters but excluding blank pages
    By Hdim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2014, 03:03 PM
  2. Pivot count excluding duplicates
    By Tom_J_W in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-02-2013, 03:14 AM
  3. Replies: 2
    Last Post: 02-11-2012, 09:33 PM
  4. Excluding non-numeric data from pivot table calcs
    By hemispheres in forum Excel General
    Replies: 1
    Last Post: 01-24-2012, 10:08 PM
  5. Pivot table average excluding zeros
    By Dipwind in forum Excel General
    Replies: 1
    Last Post: 12-17-2010, 09:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1