+ Reply to Thread
Results 1 to 2 of 2

Excluding zeros from count

  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy Excluding zeros from count

    I have pivot table that is pulling data from a page that is using the vlookup formula. I would like the table to only include fields that have data in the count. However, the pivot table is registering cells that have "0" (i.e., there's no actual data in the cell it is pull from) as having data. How can I get the pivot table count to ignore these cells?

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Excluding zeros from count

    use filtering and set filter to <>0
    Best Regards,

    Kaper

+ 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. [SOLVED] Average for non-consecutive cells excluding zeros (even when they all contain zeros)
    By pao13 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 04:32 PM
  2. Find Min/Max excluding zeros
    By BRISBANEBOB in forum Excel General
    Replies: 4
    Last Post: 04-05-2009, 09:33 PM
  3. max / min excluding zeros
    By staples in forum Excel General
    Replies: 1
    Last Post: 11-22-2008, 10:20 AM
  4. [SOLVED] Averages excluding zeros
    By Jaytee in forum Excel General
    Replies: 3
    Last Post: 07-16-2006, 11:26 AM
  5. [SOLVED] Excluding zeros in functions
    By daniel in forum Excel General
    Replies: 2
    Last Post: 02-23-2005, 06:06 AM

Tags for this Thread

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