+ Reply to Thread
Results 1 to 6 of 6

Use COUNTIF in a pivot table ?

  1. #1
    Registered User
    Join Date
    08-05-2020
    Location
    Montreal, Canada
    MS-Off Ver
    2016
    Posts
    3

    Question Use COUNTIF in a pivot table ?

    Hey guys ! I'll try to be short, here's my situation.

    In my document, I have 4 tabs (3 containing 1 table and 1 for the pivot table)

    On each of the 3 tables, I have a column that is a Yes/No question (Only possible values are "Yes" and "No")

    I want to show on my pivot table how many "Yes" and how many "No" I have individually for, let's say, department A.

    For now, it only shows how many yes/no I have in total (if I have 10 row, it'll show 10).

    I tried the COUNTIF formula and it works fine, but I have no clue on how I could put it in a pivot table, do you have any clue on how I could make this work ?

    If it's impossible, do you have any idea on how I could do something similar ?

    Thanks in advance hoping I was able to make sense, have a great day !

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,180

    Re: Use COUNTIF in a pivot table ?

    Why not add the department column to the pivot table?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-05-2020
    Location
    Montreal, Canada
    MS-Off Ver
    2016
    Posts
    3

    Re: Use COUNTIF in a pivot table ?

    Quote Originally Posted by Norie View Post
    Why not add the department column to the pivot table?
    Gotta admit I simplified the whole thing a lot, let me give you some more details

    I have 10 columns : Auditor - Job Title - Audited place - Unit - Does the employee respects the procedure (Yes no) - Same thing - Same thing - Same thing - Date - Period

    The important ones are the following : Job title, Audited place, Unit, the 4 Yes/No and the period.

    In the pivot table, I want to, firstly, filter out by Audited place (We have several hospitals, LTC facilities, etc.)

    Then, filter by Unit (there is 49 of them)

    Then, by periods (like from April 1st to April 25th is Period 1, April 26th to May 23rd is Period 2, etc.).

    Then, by Job title

    And, with that, I want to be able to see how many Yes/No I have for the employees.

    I would gladly send you the file, there is nothing private or whatever, but it's all in french. If you didn't get what I meant, I could do a quickly translated version so you could have it in front of you ?

    Thanks again for your time !

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,180

    Re: Use COUNTIF in a pivot table ?

    Attach the file.

  5. #5
    Registered User
    Join Date
    08-05-2020
    Location
    Montreal, Canada
    MS-Off Ver
    2016
    Posts
    3

    Re: Use COUNTIF in a pivot table ?

    Mhh how do I put an attachment ? Clicking on the "Attachments" thing doesn't do anything

    Edit : Uploaded it here instead, if that's okay -

    gofile.i o/d/3Drc8p (just remove the space)

    So, here's the quickly translated version, there's 2 tab named Bilan, the one with the (bad example) in it is what they used to have, they had to manually enter every numbers to calculate the comformity % of each unit, they didn't have tables to get numbers automatically.

    Let me know if you need any detail, thank you
    Attached Images Attached Images
    Last edited by Shortcube; 08-06-2020 at 07:58 AM.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,422

    Re: Use COUNTIF in a pivot table ?

    You are correct, the paperclip icon doesn't work. Please utilize the instructions in the banner at the top of the page and upload an .xlsx file.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Using Countif with pivot table
    By Curvas in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-10-2018, 01:12 PM
  2. COUNTIF within Pivot Table
    By NEXUSICON in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-30-2012, 10:32 AM
  3. Countif and Pivot Table
    By abousetta in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-16-2012, 06:22 PM
  4. Do I need COUNTIF? Pivot Table? I forget
    By jpaxton in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 01-06-2012, 01:43 PM
  5. Countif with dates in pivot table..
    By excelkeechak in forum Excel General
    Replies: 2
    Last Post: 09-08-2011, 06:20 AM
  6. Countif,Pivot table & Pivot Chart Based on data
    By excelkeechak in forum Excel General
    Replies: 5
    Last Post: 02-27-2010, 11:56 PM
  7. Countif in a Pivot Table?
    By cuteangelika in forum Excel General
    Replies: 3
    Last Post: 12-07-2006, 08:56 PM

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