+ Reply to Thread
Results 1 to 4 of 4

Countif in a Pivot Table?

  1. #1
    Registered User
    Join Date
    11-07-2006
    Posts
    26

    Countif in a Pivot Table?

    Hi All,

    Need your help but I dont know if what I want is possible... I'm a newbie by the way so please pardon me should I have done anything wrong by posting this query. I searched in the other sections and couldnt find anything similar to my dilemma.

    Ok, so I have a worksheet where data is either YES or NO. There are other columns as well so I decided to use pivot to get the count of each column. However, when it comes to these variable data, pivot just counts everything (both YES/NO). Is there any way that the count will just show yes?

    Thanks! Hope you guys can help me..

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2006
    Location
    -
    MS-Off Ver
    2010
    Posts
    388
    In the field drop-down list you should see:

    √ (Show All)
    √ No
    √ Yes

    Untick (Show All) and tick Yes and click OK.

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    The question is very cute ... too ...

    Carim

  4. #4
    Registered User
    Join Date
    11-07-2006
    Posts
    26
    Thanks. I found a better way of doing this as we cant refresh pivots in a shared workbook.

    Somebody suggested (in this forum but different topic) SUMPRODUCT and it was close to what I wanted. I probably wanted a non-formula way of doing it but sumprod's good.

    thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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